/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 votes97 views1 answer
Wait delay in sql server
SQL
0 vote107 views1 answer
Where date in datetime mysql
SQL
36 votes108 views6 answers
Rename table sql
SQL
0 vote109 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote108 views1 answer
How to update sql server version
SQL
3 votes69 views1 answer
V$session not found in oracle
SQL
5 votes150 views1 answer
Mysql created at yesterdau
SQL
28 votes104 views6 answers
Mysql change user password
SQL
0 vote106 views1 answer
Implicit inner join table alias
SQL
0 vote96 views1 answer
Docker export psql sql
SQL