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

4 votes135 views1 answer
Find tables with column name in sql
SQL
5 votes137 views3 answers
String concatenation sql server
SQL
0 vote140 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote135 views2 answers
Postgres another version
SQL
0 vote119 views2 answers
How to start postgresql laravel
SQL
11 votes167 views2 answers
Import sql file laravel cmd
SQL
0 vote126 views1 answer
Mysql jdbc timezone
SQL
0 vote140 views1 answer
Get date ISO in psql
SQL
13 votes126 views5 answers
Alter table query sql server change column
SQL
-1 vote129 views1 answer
Mysql #1064 error
SQL