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 vote249 views1 answer
Primary key start from number
SQL
1 vote214 views2 answers
Sql convert datetime to year month
SQL
2 votes211 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes229 views2 answers
Postgresql remove not null constraint
SQL
9 votes253 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote247 views1 answer
One table with another
SQL
1 vote217 views1 answer
Show table columns
SQL
0 vote228 views3 answers
Sql delete all except
SQL
0 vote317 views1 answer
Compare strings lexicographically in sql
SQL
14 votes303 views1 answer
How to export db from mysql
SQL