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 vote201 views1 answer
Virtuoso sql query tutorial
SQL
1 vote191 views1 answer
Mysql select if empty result
SQL
0 vote158 views1 answer
Dasebase_url-postgres for windows
SQL
7 votes197 views1 answer
Sql pagination oracle
SQL
2 votes186 views1 answer
Node and mysql like
SQL
0 vote185 views1 answer
Mysql local password denied
SQL
0 vote173 views1 answer
Django mysqlclient connection string
SQL
1 vote163 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote229 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote132 views2 answers
Jupyter notebook connect to database
SQL