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 vote188 views1 answer
Closure in sql
SQL
0 vote174 views1 answer
Mssql current date
SQL
31 votes186 views3 answers
SQL Server change column data type
SQL
6 votes178 views1 answer
SQL insert all columns
SQL
13 votes178 views2 answers
Get date from now() mysql
SQL
0 vote196 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote175 views1 answer
Sql server locks
SQL
-1 vote189 views1 answer
Extract Data from SQL Server into XML Format
SQL
2 votes201 views1 answer
Oracle run_duration to number
SQL
0 vote178 views1 answer
Automatically update database last seen datetime in sql
SQL