Oracle asynchronous query

-- To call a procedure asynchronously, create a auto_drop job:
BEGIN
    DBMS_SCHEDULER.create_job(
            job_name => 'My_JOB_NAME',
            job_type => 'PLSQL_BLOCK',
            job_action => 'BEGIN my_procedure(); END;',
            start_date => systimestamp,
            auto_drop => TRUE,
            enabled => TRUE
        );
END;

Similar codes

0 vote240 views1 answer
Tsql cte in a transaction
SQL
1 vote206 views1 answer
Sqlite3 read only
SQL
0 vote235 views1 answer
Show specific events on mysql
SQL
0 vote204 views1 answer
If column value is null then in mysql
SQL
0 vote206 views1 answer
Inserted row count tsql
SQL
1 vote188 views1 answer
Mysql select row with max value group by
SQL
0 vote190 views1 answer
Trim sql oracle
SQL
4 votes268 views1 answer
Oracle table statistics
SQL
0 vote213 views1 answer
Order child below the parent in mysqli
SQL
0 vote184 views1 answer
Hallo
SQL