/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 vote201 views1 answer
Mitigation of sql injection
SQL
31 votes258 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote244 views1 answer
Oracle execute package dblink
SQL
0 vote248 views1 answer
Sql combine results from two tables
SQL
1 vote276 views1 answer
Isnull sql server
SQL
-1 vote301 views1 answer
Difference berween database and data base management system
SQL
1 vote276 views1 answer
Round one decimal place mysql
SQL
2 votes296 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
3 votes276 views1 answer
Sql print all names that start with a given letter
SQL
0 vote264 views1 answer
Top frequency in sql server
SQL