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

5 votes379 views2 answers
Mysqldump password
SQL
0 vote357 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
7 votes384 views2 answers
Where keyword sql
SQL
0 vote377 views1 answer
Oracle for loop on list
SQL
2 votes371 views1 answer
Postgresql update sequence next value
SQL
0 vote350 views1 answer
Postgres declare variable
SQL
1 vote337 views1 answer
Mysql find tables with column name
SQL
1 vote359 views1 answer
Show all event schedular on mysql
SQL
0 vote358 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote370 views2 answers
Mysql select tables with name like
SQL