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 vote283 views1 answer
Mysql Case sum
SQL
10 votes340 views6 answers
Mysql set root password
SQL
0 vote294 views1 answer
Postgresql comandos basicos
SQL
1 vote304 views1 answer
Add multiple row table pl sql
SQL
1 vote334 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote298 views1 answer
Sql convert float to string
SQL
0 vote307 views1 answer
Postgres grep entire database
SQL
0 vote318 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote306 views1 answer
How to delete data from sql database in android
SQL
0 vote301 views1 answer
Postgres read table structure
SQL