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 vote94 views2 answers
Sql example query
SQL
5 votes104 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote116 views1 answer
Connect laravel to mysql on mac
SQL
0 vote135 views1 answer
Login failed for user sql server
SQL
0 vote121 views1 answer
Sql select sum group by id laravel join
SQL
0 vote110 views2 answers
Import .sql into postgres db command
SQL
0 vote107 views2 answers
How to save result of sqlite query in a table
SQL
1 vote108 views1 answer
What is a Database?
SQL
0 vote108 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote156 views1 answer
Oracle datafile max size 32gb
SQL