Search
 
SCRIPT & CODE EXAMPLE
 

SQL

pl sql asynchronous procedure calls

-- 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;
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle grant on all tables in schema 
Sql :: update query formula in excel 
Sql :: ostgreSQL version 
Sql :: oracle create datafile 
Sql :: mysql safe mode 
Sql :: convert to hexadecimal sql 
Sql :: sql current year 
Sql :: sql ends with string 
Sql :: oracle schema size 
Sql :: get two decimal places in sql server 
Sql :: sql server: select column values as comma separated string 
Sql :: oracle limit rows 
Sql :: get last week data in mysql 
Sql :: python mysql query to dataframe 
Sql :: FirebaseException ([cloud_firestore/permission-denied] The caller does not have permission to execute the specified operation.) 
Sql :: change default role snowflake 
Sql :: sql get month name 
Sql :: postgres database sizes 
Sql :: sql server week number 
Sql :: sql missing values 
Sql :: check if table exists oracle 
Sql :: sql server substring 
Sql :: psql change table schema 
Sql :: sql DATE = GETDATE() 
Sql :: sql trim all spaces 
Sql :: how to get nears location in mysql with latitude and longitude 
Sql :: drop view sql 
Sql :: add primary key with auto increment sql server 
Sql :: mysql create database utf8 
Sql :: renombrar tabla mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =