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 vote161 views1 answer
Oracle current timestamp
SQL
0 vote177 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote158 views1 answer
Mysql earlier than date
SQL
0 vote166 views1 answer
Test connection to sql server
SQL
3 votes203 views3 answers
Order by postgres
SQL
1 vote169 views1 answer
Input in mysql
SQL
0 vote167 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote154 views1 answer
Incorrect datetime value sql table error 1292
SQL
1 vote196 views1 answer
Hackerrank sql test solutions
SQL
0 vote179 views1 answer
Laravel migration sql dump
SQL