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 vote170 views1 answer
Datagrip go to line
SQL
0 vote170 views3 answers
Sql count condition
SQL
0 vote180 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote166 views1 answer
Postgresql default value boolean
SQL
12 votes201 views4 answers
How to drop all tables in postgresql
SQL
0 vote168 views1 answer
Mysql date minus 1 day
SQL
5 votes176 views2 answers
Get columns number sql
SQL
5 votes172 views1 answer
Mysql count newlines in field
SQL
0 vote168 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
-1 vote165 views1 answer
Ssms connect with connection string
SQL