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 vote227 views4 answers
Restart MySQL
SQL
0 vote192 views1 answer
Backup a table in sql
SQL
0 vote222 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote245 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote218 views3 answers
Fetlife
SQL
0 vote212 views1 answer
Azure sql server check foreign key
SQL
3 votes217 views5 answers
Duplicate table sql
SQL
1 vote205 views1 answer
Find difference in dates sql
SQL
0 vote214 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote234 views2 answers
Greater than sql server
SQL