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 vote273 views1 answer
Postgresql create query
SQL
0 vote273 views1 answer
List all indexes postgres
SQL
0 vote213 views0 answer
SQL
-1 vote261 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote261 views1 answer
Mysql select where field like in list
SQL
0 vote279 views1 answer
Mysql dump with table query
SQL
2 votes247 views1 answer
Sqlite indexes
SQL
1 vote247 views1 answer
Temp table vs variable table in sql server
SQL
8 votes255 views1 answer
Oracle all_source package body
SQL
0 vote290 views1 answer
How to get button for every record from mysql
SQL