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

1 vote309 views2 answers
Replace text in sql
SQL
0 vote308 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote336 views2 answers
How to add CHECK constraint to a column in postgres
SQL
62 votes438 views8 answers
Mysql add column
SQL
7 votes359 views2 answers
How to create index mysql
SQL
0 vote264 views1 answer
Oracle sql developer script output limit
SQL
0 vote303 views2 answers
Return the number of records in a single table mysql
SQL
0 vote324 views1 answer
Open postgresql.conf in centos
SQL
0 vote347 views3 answers
How to assign custom id in mysql
SQL
15 votes299 views2 answers
How to know the username of postgresql
SQL