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 vote233 views1 answer
Delete first row in sql
SQL
0 vote219 views1 answer
Get employees if not contains in sql
SQL
0 vote231 views1 answer
Query string starts with vowels
SQL
0 vote185 views1 answer
Postgres delete where id in
SQL
0 vote230 views1 answer
Sql developer connect to sql server
SQL
1 vote247 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote271 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote232 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote216 views2 answers
Mysql does sentance contain word
SQL
0 vote238 views1 answer
Str_to_date sql server
SQL