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 votes163 views1 answer
Mysql auto increment jumping
SQL
1 vote126 views1 answer
Postgres kill pid
SQL
0 vote167 views1 answer
Mysql max number not returning correct value
SQL
0 vote163 views1 answer
How to add session data into mysql database from button
SQL
10 votes209 views4 answers
Sql server pagination
SQL
0 vote186 views3 answers
How to assign custom id in mysql
SQL
0 vote185 views1 answer
Show the colums of table sql
SQL
1 vote213 views1 answer
Drop colum oracle 18c
SQL
0 vote162 views3 answers
Drop multiple columns in sql
SQL
1 vote163 views1 answer
Show table columns
SQL