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 vote174 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote104 views1 answer
Sql datediff db2
SQL
-1 vote129 views1 answer
Search all sql tables for a value
SQL
5 votes126 views6 answers
Sql foreign key
SQL
0 vote95 views1 answer
Sql select most frequent value in group
SQL
0 vote98 views1 answer
10000000000000000000 am to meters
SQL
31 votes108 views3 answers
Sql count(*)
SQL
1 vote103 views1 answer
Oracle start job
SQL
0 vote105 views1 answer
Mysql bash execute sql file
SQL
2 votes135 views1 answer
Search query in mysql
SQL