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 vote262 views1 answer
Wherein mysql
SQL
3 votes225 views2 answers
MySQL query to get column names
SQL
13 votes257 views6 answers
Mysql remove duplicates
SQL
0 vote201 views1 answer
Acual month sql
SQL
0 vote229 views1 answer
For row in sql database python loop
SQL
0 vote211 views1 answer
Sql find table by name
SQL
0 vote207 views1 answer
Plpgsql raise notice
SQL
0 vote201 views1 answer
Python list from sql
SQL
1 vote218 views1 answer
Sql set auto increment back to 0
SQL
9 votes259 views3 answers
Postgres make sql dump
SQL