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

28 votes121 views6 answers
Distinct sql
SQL
1 vote158 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote139 views1 answer
Sql get month and year from date
SQL
7 votes158 views5 answers
Show details of table postgres
SQL
42 votes228 views6 answers
Install beautifulsoup
SQL
0 vote152 views1 answer
Php delete database
SQL
1 vote167 views3 answers
How to reset id column in sql server
SQL
0 vote151 views1 answer
Mysql disable query caching
SQL
0 vote150 views1 answer
Sql delete where x or y or z
SQL
15 votes159 views6 answers
Psql
SQL