Oracle asynchronous query

-- 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 vote148 views1 answer
Sql combine results from two tables
SQL
0 vote142 views1 answer
Sql reverse order of results
SQL
0 vote233 views1 answer
Drop check command
SQL
1 vote153 views1 answer
Mysql select and count left join
SQL
0 vote158 views1 answer
Selecting all columns from table sql database
SQL
1 vote136 views1 answer
Oracle select first result
SQL
0 vote135 views2 answers
Imageview setimageresource null
SQL
1 vote144 views1 answer
Postgres convert exisiting column to text
SQL
0 vote141 views1 answer
Initcap in mysql
SQL
0 vote148 views1 answer
Mysql cast null to string
SQL