/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 vote238 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote199 views1 answer
Postgres declare variable
SQL
0 vote200 views1 answer
Get schema of table sql
SQL
0 vote190 views1 answer
Sql common columns
SQL
1 vote197 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
16 votes243 views1 answer
Mysql mediumint max value
SQL
0 vote150 views1 answer
Java spring boot connect to sql server
SQL
0 vote153 views1 answer
Hangfire clean script
SQL
20 votes178 views2 answers
Mysql bigint max value
SQL
1 vote184 views4 answers
Sql now
SQL