/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

2 votes272 views2 answers
Null column to 0 in mysql
SQL
0 vote225 views1 answer
Sql query to delete row by id
SQL
1 vote236 views1 answer
Order by oracle
SQL
1 vote230 views2 answers
String to date postgres
SQL
0 vote245 views1 answer
Ver usuarios mysql
SQL
2 votes217 views1 answer
Convert series number to date in sql
SQL
1 vote233 views1 answer
Sql Split string function
SQL
1 vote237 views1 answer
Get table which have specific columns in mysql
SQL
0 vote197 views1 answer
Plsql trigger insert update
SQL
0 vote315 views1 answer
Current month transactions in mysql
SQL