/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

2 votes290 views1 answer
How to show the whole table in sql
SQL
0 vote298 views1 answer
Drop-toys-table
SQL
0 vote297 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote315 views1 answer
Psql view enum values
SQL
0 vote270 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote329 views1 answer
How to convert external table to managed table in hive
SQL
0 vote286 views2 answers
Sql query in dax power bi
SQL
9 votes293 views1 answer
Mysql check date range
SQL
0 vote236 views1 answer
Ms sql print more than 1 variable
SQL
0 vote285 views1 answer
Sql anywhere create procedure
SQL