/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 vote181 views2 answers
How to save result of sqlite query in a table
SQL
0 vote177 views4 answers
Restart MySQL
SQL
0 vote225 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
11 votes179 views1 answer
Get ddl materialized view oracle
SQL
1 vote172 views1 answer
Database Queries
SQL
0 vote177 views1 answer
Number(10 2) in sql means
SQL
5 votes168 views2 answers
Add column postgres with default value
SQL
1 vote168 views1 answer
Sql delete row with auto increment
SQL
0 vote152 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote181 views1 answer
Low level operator in dbms
SQL