/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 vote371 views3 answers
Sql server import json
SQL
0 vote391 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
4 votes347 views1 answer
Mysql ip address
SQL
25 votes361 views3 answers
Mysql command show tables
SQL
1 vote341 views1 answer
Truncate left characters mysql
SQL
32 votes386 views6 answers
Insert select
SQL
1 vote335 views1 answer
Truncate table in postgresql and reset id
SQL
1 vote363 views1 answer
Oracle duration between timestamps
SQL
14 votes364 views4 answers
Online sql compiler
SQL
0 vote358 views1 answer
Case when with count and combining similar values in sql
SQL