/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 votes83 views1 answer
How to show the whole table in sql
SQL
0 vote73 views4 answers
How to get max salary in each department in sql
SQL
0 vote74 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
0 vote89 views1 answer
Load data infile mariadb slow
SQL
0 vote88 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote62 views1 answer
Csv to sqlite python
SQL
0 vote69 views1 answer
Like date sql server not working
SQL
1 vote87 views1 answer
Oracle repeat_interval 5 minutes
SQL
7 votes71 views1 answer
Mysql unsafe update
SQL
0 vote86 views1 answer
Postgres grep entire database
SQL