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

1 vote176 views1 answer
Mysql select row with max value group by
SQL
0 vote231 views1 answer
Tsql cte in a transaction
SQL
7 votes190 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote152 views1 answer
Deleted table in sql trigger
SQL
16 votes201 views4 answers
Mysql import from sql file
SQL
3 votes228 views2 answers
@sqlresultsetmapping
SQL
1 vote149 views1 answer
Ms sql - add one hour to time
SQL
2 votes208 views1 answer
Oracle convert run_duration to number
SQL
14 votes214 views3 answers
How to add default constraint in mysql
SQL
0 vote200 views1 answer
Postgresql get diff between two dates in Months
SQL