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

60 votes333 views6 answers
Add column in sql
SQL
2 votes178 views1 answer
Mysql now format
SQL
2 votes138 views1 answer
How to select first row of database sql
SQL
0 vote141 views2 answers
Identity syntax in sql
SQL
0 vote131 views2 answers
Sqlite
SQL
0 vote146 views2 answers
Coursera spark sql max count
SQL
0 vote202 views1 answer
Check user sql password from command line
SQL
3 votes137 views2 answers
Sql end of month
SQL
3 votes133 views2 answers
Current year sql
SQL
6 votes141 views1 answer
Oracle pl sql source
SQL