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

1 vote120 views2 answers
Sql for date greater than
SQL
0 vote143 views1 answer
Mysql into outfile with headers
SQL
1 vote119 views1 answer
Local sql server
SQL
1 vote117 views3 answers
Read all columns of a table sql
SQL
0 vote148 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
14 votes121 views3 answers
Trim sql
SQL
0 vote120 views1 answer
Create a table from one field of another table
SQL
5 votes123 views1 answer
Oracle find foreign key dependencies
SQL
0 vote129 views1 answer
Alter table engine mysql
SQL
27 votes138 views6 answers
Sql update record
SQL