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 vote192 views1 answer
Psql datetime grather than
SQL
0 vote209 views1 answer
Linked server delete openquery
SQL
0 vote365 views1 answer
The differnece between to values in sql
SQL
1 vote209 views1 answer
Altrer name column postgres
SQL
0 vote205 views1 answer
Get clob size oracle
SQL
6 votes214 views4 answers
Mysql update set
SQL
0 vote226 views1 answer
How to change the field size of an existing column
SQL
-1 vote204 views1 answer
Pl/sql how to delete a trigger
SQL
2 votes210 views2 answers
Mysql find max value row
SQL
25 votes226 views1 answer
How to update an attribute in MySQL
SQL