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 vote243 views1 answer
How to insert multiple rows in mysql using laravel
SQL
-2 votes234 views1 answer
Mysql not empty
SQL
0 vote237 views2 answers
Python mysql create table if not exists
SQL
6 votes226 views5 answers
Get current date sql
SQL
0 vote229 views1 answer
Optimize sql query
SQL
0 vote264 views1 answer
Nuget sqllite-net-pcl
SQL
1 vote246 views1 answer
Sql string function update replace
SQL
0 vote229 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote239 views1 answer
Raven ql select count
SQL
-1 vote254 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL