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 vote216 views1 answer
Hour differeence in mysql
SQL
1 vote182 views1 answer
Firebase bigquery cloud message
SQL
3 votes223 views1 answer
Oracle user quota on tablespace
SQL
1 vote256 views1 answer
Postgresql pass array in function
SQL
0 vote197 views1 answer
Mysql beautifier terminla
SQL
1 vote202 views1 answer
Select random sample sql
SQL
1 vote147 views1 answer
Alter user mysql native password
SQL
0 vote224 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
3 votes247 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote182 views1 answer
Alter table fulltext
SQL