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

1 vote312 views1 answer
Oracle create index if not exists
SQL
1 vote320 views2 answers
Regex starts with
SQL
0 vote260 views1 answer
Ms sql print more than 1 variable
SQL
1 vote322 views1 answer
Window function mysql
SQL
2 votes307 views1 answer
Sql skip the first row
SQL
0 vote315 views1 answer
Unique element in sql
SQL
2 votes337 views4 answers
Check timezone of mysql database
SQL
0 vote307 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote329 views1 answer
Oracle query to find schema you are working on
SQL
0 vote307 views1 answer
Use between operator in mysql
SQL