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

2 votes345 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote344 views1 answer
Supprimer les valeur d'une table mysql
SQL
2 votes375 views1 answer
Datefromparts mssql
SQL
1 vote326 views1 answer
Postgresql delete cascade
SQL
0 vote359 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote324 views1 answer
Add multiple field in table sql
SQL
0 vote324 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote324 views1 answer
Postgresql remove new line from string
SQL
0 vote356 views1 answer
Mysql collation portugues brasil
SQL
0 vote289 views1 answer
Select mysql limit to 2 decimal places
SQL