/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 vote134 views1 answer
Convert rows to columns in sql server
SQL
0 vote145 views1 answer
Sql check if column exists
SQL
4 votes145 views1 answer
Oracle show errors
SQL
10 votes140 views2 answers
Oracle alter sequence nextval
SQL
0 vote185 views3 answers
Get count of null in column sql
SQL
2 votes138 views1 answer
Q operator in plsql
SQL
10 votes106 views2 answers
Mysql select timestamp group by day
SQL
0 vote160 views1 answer
Using distinct and count together in sql
SQL
3 votes169 views1 answer
How to add unique constraint in mysql table
SQL
2 votes153 views2 answers
How to run postgresql in linux
SQL