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 vote268 views2 answers
Raise notice in postgresql function
SQL
1 vote244 views1 answer
Add sequence postgres
SQL
0 vote289 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote215 views1 answer
How to check oracle index table
SQL
4 votes289 views1 answer
Sql select limit range
SQL
2 votes260 views1 answer
Sql server current date minus 5 years
SQL
0 vote259 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote254 views1 answer
View to table
SQL
0 vote265 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
9 votes254 views2 answers
Sql limit order by
SQL