Oracle asynchronous update

-- 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 vote217 views1 answer
Mysql query to select the highest value
SQL
0 vote199 views1 answer
Mysql show category once count how many products
SQL
0 vote224 views1 answer
Check constraint is violated
SQL
0 vote219 views1 answer
Sql with example
SQL
3 votes206 views3 answers
C# sql select
SQL
31 votes198 views3 answers
Sql count
SQL
12 votes204 views4 answers
Mysql ifnull
SQL
25 votes215 views3 answers
How to use a database to see tables mysql
SQL
19 votes207 views5 answers
Mysql between date range
SQL
1 vote209 views1 answer
Postgres concat_ws
SQL