/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

0 vote115 views1 answer
Migration graphql
SQL
0 vote117 views1 answer
Create-table-with-index-organization
SQL
0 vote68 views1 answer
Mysql find foreign key references
SQL
-1 vote112 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote142 views1 answer
Add new column in sql with foreign key
SQL
0 vote120 views1 answer
SQL: calculate hours from two dates
SQL
0 vote158 views2 answers
Wordpress change url in database
SQL
0 vote104 views1 answer
Java mysql date format
SQL
1 vote111 views1 answer
STOP message of how many rows affected sql
SQL
0 vote118 views1 answer
Less than and between in sql query
SQL