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 vote152 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote145 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote163 views1 answer
Kill mysqld_safe process mariadb
SQL
3 votes141 views4 answers
Order by desc postgres
SQL
5 votes141 views1 answer
Oracle find foreign key dependencies
SQL
0 vote142 views1 answer
Python sql last insertend
SQL
0 vote132 views1 answer
How to get initials in sql
SQL
0 vote145 views1 answer
Initcap in mysql
SQL
0 vote152 views1 answer
Sql list dates between two dates
SQL
0 vote212 views1 answer
Sql delete row from table where id
SQL