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

9 votes130 views3 answers
Mysql run sql file
SQL
12 votes117 views2 answers
Update column data type postgres
SQL
0 vote110 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
5 votes118 views1 answer
Purge undo tablespace usage
SQL
0 vote120 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote118 views1 answer
Mariadb case switch
SQL
3 votes110 views1 answer
Insert into table from another table mysql
SQL
1 vote121 views1 answer
How to select department from table
SQL
0 vote113 views1 answer
Insert or update cassandra
SQL
3 votes127 views2 answers
Tsql join multiple record in one string
SQL