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

2 votes343 views2 answers
Created at and updated at in mysql
SQL
16 votes358 views3 answers
Update table from another table
SQL
1 vote323 views1 answer
Create sample data postgresql
SQL
0 vote368 views1 answer
Gcloud sql instance list
SQL
0 vote360 views2 answers
Sql count number of rows after group by
SQL
0 vote324 views1 answer
Count the table indatabase
SQL
1 vote335 views3 answers
Postgresql crete view
SQL
0 vote340 views1 answer
Create table with float datatype in sql server
SQL
0 vote368 views1 answer
Postgresql inheritance
SQL
3 votes367 views2 answers
Sql add year to date
SQL