/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 vote366 views1 answer
Sql log file inof
SQL
0 vote343 views1 answer
Sql server set complex constraints
SQL
-1 vote330 views1 answer
Mysql delete duplicate rows except one
SQL
5 votes315 views1 answer
Sql first day of current year
SQL
-1 vote346 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote374 views1 answer
Mysql take number in string
SQL
0 vote288 views1 answer
Oracle sysdba connect as another user
SQL
0 vote345 views1 answer
Plpgsql raise notice
SQL
4 votes351 views1 answer
For loop postgresql
SQL
23 votes353 views3 answers
Sql where contains part of string
SQL