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 vote120 views1 answer
Mysql subdate
SQL
0 vote113 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote133 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote133 views1 answer
Sqlite update where exists
SQL
7 votes112 views6 answers
Group_concat mysql
SQL
1 vote120 views1 answer
Mariadb alter user host
SQL
0 vote131 views1 answer
Cannot start database server xampp mac os
SQL
0 vote82 views1 answer
Query for maximum salary
SQL
16 votes117 views3 answers
Tsql rename column name
SQL
-1 vote113 views8 answers
Create Trigger in phpMyAdmin
SQL