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

5 votes299 views1 answer
Oracle columns in all_tables
SQL
1 vote332 views1 answer
Sql server delete top 1000
SQL
0 vote318 views1 answer
Mysql aspas simples
SQL
0 vote296 views1 answer
Postgres in operator with comma separated values
SQL
0 vote310 views4 answers
Mysql desactivar trigger
SQL
0 vote398 views1 answer
Run docker container with database as rds metabase
SQL
-1 vote292 views1 answer
Export mysql table to file
SQL
7 votes310 views2 answers
Execute mysql file
SQL
0 vote330 views1 answer
Sql missing values
SQL
0 vote293 views1 answer
Mysql get 2nd value in comma separated list
SQL