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 vote113 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote116 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
20 votes102 views2 answers
Counting in sql
SQL
0 vote127 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote119 views1 answer
PGSQL dynamic table name
SQL
0 vote112 views1 answer
IS THEre any difference between using default and := in plsql
SQL
1 vote103 views2 answers
Mysql order by date asc null last
SQL
9 votes106 views4 answers
SQL Date Format
SQL
0 vote148 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote104 views1 answer
Get yesterday date ISO in psql
SQL