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 vote241 views1 answer
Sqlite update where exists
SQL
0 vote185 views2 answers
Temp Space
SQL
3 votes238 views1 answer
Query less than datetime sql
SQL
0 vote262 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote421 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
2 votes193 views1 answer
SQL IF ELSE
SQL
1 vote210 views1 answer
OSError: mysql_config not found
SQL
0 vote200 views1 answer
Second Step in installing SQL workbench
SQL
0 vote176 views2 answers
Functions with parameters SQL
SQL
0 vote219 views1 answer
Like and not like together in sql
SQL