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 vote269 views1 answer
Mysql find foreign key references
SQL
0 vote319 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote314 views1 answer
Sql server python connection
SQL
0 vote336 views1 answer
Sql server Cost Fifo query
SQL
1 vote300 views2 answers
T-sql random number for each row
SQL
0 vote267 views1 answer
Oracle sysdba connect as another user
SQL
11 votes321 views3 answers
Change column name sql server management studio
SQL
0 vote295 views1 answer
Import mysql'
SQL
0 vote319 views1 answer
Postgresql certain first 4 characters in string
SQL
8 votes410 views3 answers
Find table for column name in sql
SQL