/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 vote166 views1 answer
MySql count occurences more than"
SQL
0 vote176 views1 answer
Get date ISO in psql
SQL
2 votes162 views1 answer
Mysql how to store lat,lng
SQL
0 vote178 views1 answer
Mysql, how to query the table comments?
SQL
1 vote174 views1 answer
Error code 1292 mysql workbench
SQL
12 votes176 views6 answers
Between in sql
SQL
1 vote169 views1 answer
Load sql into mamp
SQL
0 vote171 views2 answers
How to count codition
SQL
0 vote165 views1 answer
Oracle sql generate list of days
SQL
13 votes160 views6 answers
Restart postgresql
SQL