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 vote225 views1 answer
Create dump file mysql workbench
SQL
0 vote209 views1 answer
Sql file in postgres with pgadmin
SQL
1 vote214 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote213 views1 answer
Oracle exchange subpartition
SQL
-1 vote200 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
6 votes210 views1 answer
Oracle desc table primary key
SQL
0 vote225 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote216 views2 answers
Php convert dbf to mysql
SQL
0 vote242 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote219 views2 answers
How to generate a unique random number in mysql
SQL