/SQL/Oracle create program if not exists

Oracle create program if not exists

DECLARE
    existing_program NUMBER;
BEGIN
    SELECT count(*) INTO existing_program
    FROM ALL_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'prog_name' AND OWNER='owner';
    IF existing_program = 1 THEN
        dbms_scheduler.DROP_PROGRAM(PROGRAM_NAME => 'prog_name');
    END IF;
END;
/
BEGIN DBMS_SCHEDULER.create_program(program_name => 'owner.prog_name', ...); END;

Similar codes

4 votes216 views3 answers
Rename table column postgresql
SQL
4 votes217 views3 answers
Copy table postgres
SQL
0 vote219 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote246 views1 answer
Mysql 3 months ago
SQL
2 votes199 views1 answer
Get first 3 letters name in sql
SQL
0 vote218 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote220 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote219 views1 answer
Mysql select if empty result
SQL
0 vote223 views1 answer
Insert array into mysql column
SQL
0 vote237 views1 answer
Comparing with today and yesterday record in sql query
SQL