/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 vote268 views1 answer
Soql more than today
SQL
1 vote263 views2 answers
Difference between in and between in sql
SQL
5 votes269 views1 answer
Oracle asynchronous query
SQL
0 vote273 views1 answer
Mysql procedure between two tables
SQL
0 vote291 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote272 views1 answer
Install postgresql 12 on debian 10
SQL
5 votes264 views1 answer
Ascending order and where in sql
SQL
1 vote282 views1 answer
Oracle drop chain step
SQL
0 vote272 views1 answer
Heidisql check how much space a row
SQL
0 vote266 views1 answer
Select top 3 sql
SQL