/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 vote195 views1 answer
Max mysql
SQL
0 vote166 views1 answer
Dnsmasq.conf location macos
SQL
0 vote199 views1 answer
Sql server concat null
SQL
-2 votes193 views2 answers
Union vs union all in sql
SQL
0 vote186 views1 answer
Price-colour
SQL
0 vote189 views1 answer
Mysql create index lost connection
SQL
1 vote196 views1 answer
Mysql column start with string
SQL
0 vote207 views1 answer
Duplix print in Smartforms
SQL
0 vote137 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
1 vote199 views3 answers
How to reset id column in sql server
SQL