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

25 votes433 views5 answers
Mysql replace text
SQL
1 vote348 views3 answers
Drop unique key constraint in sql server
SQL
-1 vote343 views1 answer
Add bool column in sql
SQL
0 vote358 views1 answer
Proc sql not in working
SQL
0 vote377 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote349 views2 answers
Athena drop partition
SQL
4 votes388 views3 answers
Sql find second highest salary employee
SQL
0 vote367 views1 answer
Groupby sort sql hive
SQL
0 vote361 views1 answer
Where name ends in SQL
SQL
2 votes345 views1 answer
Get hour from date sql
SQL