Oracle asynchronous update

-- 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 vote272 views1 answer
Sql cross apply vs join
SQL
4 votes295 views4 answers
Rollback in sql
SQL
15 votes284 views2 answers
Select Options
SQL
0 vote294 views1 answer
Open postgresql.conf in centos
SQL
2 votes310 views5 answers
Install postgresql 10 centos 7
SQL
0 vote306 views2 answers
Mysql calcular idade
SQL
3 votes280 views1 answer
Oracle rollback
SQL
1 vote275 views1 answer
Can not connect to mysql server
SQL
0 vote299 views1 answer
Like sql for second letter of the family name
SQL
0 vote308 views1 answer
Shrink database file in sql server
SQL