/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

19 votes144 views2 answers
Mysql tinyint max value
SQL
0 vote95 views1 answer
Psql not found windows
SQL
37 votes150 views3 answers
Duplicate records in sql
SQL
0 vote131 views1 answer
Search In the Database using Text
SQL
0 vote172 views1 answer
C# sql transaction multiple connections
SQL
0 vote142 views1 answer
Mysql max number not returning correct value
SQL
0 vote158 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote137 views1 answer
Call rest api from postgresql
SQL
0 vote176 views2 answers
Suse stop MySQL
SQL
0 vote135 views1 answer
Resulting Query
SQL