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 vote130 views1 answer
Sql pick random row
SQL
0 vote130 views1 answer
Sql query to check if column contains alphabets
SQL
17 votes146 views6 answers
MySQL ORDER BY
SQL
0 vote121 views1 answer
Limiting query result using where in sql
SQL
13 votes136 views2 answers
Sql online compiler
SQL
10 votes168 views4 answers
Sql server pagination
SQL
6 votes166 views3 answers
Mysql change auto_increment start value
SQL
3 votes131 views2 answers
Truncate all tables
SQL
0 vote131 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote125 views1 answer
Check index sql server
SQL