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

38 votes342 views6 answers
Alter table mysql
SQL
15 votes279 views2 answers
How to drop database name in postgresql
SQL
3 votes293 views1 answer
Oracle get trigger ddl
SQL
7 votes296 views6 answers
Reset identity column in sql server
SQL
0 vote305 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote320 views1 answer
Oracle to_number
SQL
0 vote275 views1 answer
Ms Sql set us timezone
SQL
1 vote296 views1 answer
Postgres convert date to string
SQL
0 vote329 views1 answer
Amount of entries in a table psql
SQL
10 votes308 views1 answer
Oracle dba_dependencies
SQL