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

6 votes174 views4 answers
Eloquent to sql with bindings
SQL
1 vote170 views1 answer
Mysql check table exists
SQL
3 votes161 views3 answers
Mysql select table names
SQL
2 votes173 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote174 views1 answer
Mysql docker image for macbook m1
SQL
1 vote203 views1 answer
Sql random sampling per group
SQL
2 votes169 views1 answer
Mysql create user with mysql_native_password
SQL
2 votes162 views1 answer
Sqlite indexes
SQL
2 votes174 views1 answer
Wait delay in sql server
SQL
0 vote174 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL