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 vote375 views1 answer
Min mysql
SQL
0 vote437 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
4 votes377 views2 answers
Float postgres
SQL
2 votes345 views1 answer
Oracle current date without time
SQL
1 vote325 views1 answer
Mysql find tables with column name
SQL
1 vote388 views1 answer
Concat first name and last name in mysql
SQL
0 vote392 views1 answer
Postgres foreign key multiple columns
SQL
5 votes344 views2 answers
Oracle rename table
SQL
0 vote412 views1 answer
Remove mysql from centos 7
SQL
1 vote356 views3 answers
Mysql connection string
SQL