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 vote267 views1 answer
If column value is null then in mysql
SQL
4 votes265 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote256 views1 answer
Replace \n sql
SQL
1 vote245 views1 answer
Select not matching data from two tables
SQL
2 votes282 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote255 views1 answer
How to print out column name differently in mysql
SQL
7 votes280 views3 answers
Sql set
SQL
0 vote242 views1 answer
Oracle index hint multiple tables example
SQL
0 vote263 views1 answer
Get the previous column of a table in mysql
SQL
10 votes251 views3 answers
Insert into auto increment mysql
SQL