/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

1 vote129 views1 answer
Get all db sizes in mysql server
SQL
2 votes119 views1 answer
Can you use a where clause for a child query
SQL
12 votes137 views1 answer
Script to add new column in table sql
SQL
0 vote124 views1 answer
Create table employees oracle
SQL
0 vote147 views1 answer
Sql getdate minus 1 day without time
SQL
5 votes131 views2 answers
Get number of columns sql
SQL
0 vote123 views1 answer
Dump only schema
SQL
0 vote186 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes127 views1 answer
Mysql sysdate
SQL
0 vote231 views1 answer
Mysql select field if condition
SQL