use job.
first make sure parameter job_enqueue_processes<>0, and internal <>0,
then write a simple procedure to do the update statement.
and dbms_job.submit to add a job.
for detailed help. refer to oracle supplied plsql package reference on otn.oracle.com