/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

1 vote187 views2 answers
Pl sql case
SQL
-2 votes192 views2 answers
Sqlserver docker
SQL
0 vote191 views1 answer
10000000000000000000 am to meters
SQL
0 vote187 views1 answer
If column value is null then in mysql
SQL
0 vote183 views1 answer
Select other columns with distinct
SQL
0 vote202 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
4 votes189 views2 answers
Oracle default date format
SQL
3 votes198 views2 answers
Host is not allowed to connect to this mysql server
SQL
5 votes181 views1 answer
How to get all dates in a month in oracle
SQL
3 votes173 views1 answer
Uppercase and lowercase in sql
SQL