Submit a job and run : DBMS_JOB « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_JOB

SQL>
SQL> set echo on
SQL>
SQL> create table t ( msg varchar2(20), cnt int );

Table created.

SQL>
SQL> insert into t select 'from SQL*PLUS', count(*) from session_roles;

1 row created.

SQL>
SQL> variable n number
SQL>
SQL> exec dbms_job.submit(:n,'insert into t select ''from job'', count(*) from session_roles;');

PL/SQL procedure successfully completed.

SQL>
SQL> print n

         N
----------
       181

SQL>
SQL> exec dbms_job.run(:n);

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

MSG                         CNT
-------------------- ----------
from SQL*PLUS                12
from job                      0

SQL> drop table t;

Table dropped.

SQL>