Oracle create program if no 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 vote214 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote217 views1 answer
Sql server delete records with specific date
SQL
0 vote236 views2 answers
Dbms interview questions
SQL
1 vote205 views1 answer
Postgres get month name from date
SQL
0 vote218 views1 answer
Rails sql query converstion
SQL
11 votes191 views1 answer
Creating tables in sql with python
SQL
0 vote211 views1 answer
Query for backup a database at another location in file system
SQL
0 vote174 views1 answer
Hibernate xml property MySQL url, username and password
SQL
11 votes174 views4 answers
MYSQL LOGIN
SQL
0 vote174 views1 answer
Sql remove last x char
SQL