/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

5 votes275 views3 answers
Create function in postgresql
SQL
0 vote223 views1 answer
Denormalise SQL command
SQL
0 vote221 views1 answer
Mql5 datetime get hour
SQL
15 votes238 views5 answers
If null mysql
SQL
0 vote225 views2 answers
Sql update top 100
SQL
11 votes260 views1 answer
Oracle export view ddl
SQL
0 vote239 views2 answers
Mysql calcular idade
SQL
16 votes238 views5 answers
Select last row in sql
SQL
0 vote237 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote217 views1 answer
Update one column from another column in same table
SQL