/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 vote195 views1 answer
Oracle current date minus 1 day
SQL
0 vote163 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote175 views1 answer
Sql server datetime
SQL
12 votes161 views5 answers
Sql primary key
SQL
1 vote189 views1 answer
Mysql alter decimal precision
SQL
0 vote170 views1 answer
Mysql export data with a where clause
SQL
0 vote164 views1 answer
Sql get month from date
SQL
1 vote175 views1 answer
How to put value in variable mysql
SQL
2 votes168 views1 answer
Set column to not null mysql
SQL
0 vote178 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL