/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

11 votes302 views2 answers
Import sql file laravel cmd
SQL
2 votes337 views4 answers
Check timezone of mysql database
SQL
0 vote339 views2 answers
How to count codition
SQL
0 vote342 views1 answer
Sqlite woth cmake
SQL
2 votes328 views2 answers
Postgresql search all tables for column name
SQL
2 votes368 views1 answer
Sql compare strings
SQL
8 votes338 views1 answer
My sql version
SQL
0 vote334 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote319 views1 answer
Subquery aggregation
SQL
5 votes299 views2 answers
Oracle tables with column name
SQL