/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 vote202 views1 answer
Database get 10 user aleatory
SQL
2 votes181 views1 answer
Mysql sysdate
SQL
0 vote214 views1 answer
Mysql get only the field names in a table
SQL
0 vote202 views1 answer
Typical max-connect-errors mysql
SQL
5 votes193 views1 answer
Oracle nls session
SQL
0 vote210 views1 answer
Learnxinyminutes sql
SQL
1 vote191 views2 answers
Sql groub by count
SQL
5 votes189 views1 answer
Commentaire table oracle
SQL
0 vote192 views1 answer
Sql auto_increment syntax
SQL
0 vote182 views1 answer
Sql date between one week
SQL