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 vote94 views1 answer
SQL server select to get sum of hours
SQL
5 votes103 views2 answers
Create table mysql example auto_increment
SQL
0 vote104 views1 answer
Python connect microsoft sql server
SQL
0 vote99 views2 answers
Android sqlite tutorial for beginners
SQL
3 votes106 views1 answer
How to uninstall microsoft sql server
SQL
1 vote110 views1 answer
Vagrant mysql downgrade version
SQL
10 votes191 views4 answers
Mysql if else
SQL
25 votes97 views6 answers
Import mysql database command line
SQL
0 vote115 views1 answer
Mysql update set sum
SQL
0 vote109 views1 answer
Setval in postgres
SQL