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 vote156 views1 answer
Tsql find foreign key references
SQL
0 vote149 views1 answer
Oracle table privileges
SQL
0 vote149 views1 answer
Sql server remove 0 from left
SQL
0 vote155 views1 answer
Postgresql using reserved word as column name
SQL
0 vote145 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote170 views1 answer
Postgressql uuid
SQL
19 votes154 views6 answers
Sql create table
SQL
5 votes158 views2 answers
Create function postgresql
SQL
0 vote174 views2 answers
Oracle ora-00054 how to unlock
SQL
20 votes149 views2 answers
Mysql bigint max value
SQL