/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

4 votes359 views2 answers
Select first and last row mysql
SQL
7 votes386 views4 answers
Index in mysql
SQL
12 votes379 views10 answers
Google
SQL
1 vote342 views1 answer
Sql list all procedures
SQL
3 votes306 views1 answer
Postgresql where current year
SQL
3 votes499 views9 answers
Linq to sql converter online
SQL
6 votes385 views3 answers
How to delete table sqlite
SQL
0 vote410 views2 answers
What is rownum in oracle
SQL
0 vote370 views1 answer
Sql alter table add column if exists
SQL
0 vote343 views1 answer
Install mysql 8 linux
SQL