/SQL/Oracle create program if not exists

Oracle create program if not 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 vote126 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote146 views1 answer
Mysql order by where condition sub query
SQL
0 vote132 views1 answer
Show tables in cassandra cql
SQL
41 votes194 views6 answers
Alter table add column in SQL Server
SQL
0 vote137 views1 answer
Postgresql create query
SQL
0 vote125 views1 answer
Différence entre deux dates sql oracle
SQL
5 votes130 views3 answers
Sql make column nullable
SQL
0 vote120 views1 answer
Psql check if value in array
SQL
0 vote134 views1 answer
Mysql reset wp_options
SQL
5 votes139 views1 answer
Oracle list days between two dates
SQL