/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 vote123 views1 answer
Show table details postgresql
SQL
0 vote121 views1 answer
Postgresql array to rows
SQL
25 votes113 views6 answers
Modify column name in mysql
SQL
0 vote116 views2 answers
Auto increment column in mysql query results
SQL
0 vote116 views1 answer
Postegresql update to null
SQL
5 votes124 views2 answers
Ranking functions in sql
SQL
0 vote134 views1 answer
How to fetch data from database in sql
SQL
0 vote118 views1 answer
Trigger value from maltiple table to single table mysql
SQL
4 votes73 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
-1 vote106 views3 answers
Mysql get age from date
SQL