Oracle create program if no 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 vote187 views1 answer
Snowflake drop column
SQL
1 vote127 views1 answer
Mysql collation
SQL
0 vote230 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
16 votes193 views2 answers
Sql vs nosql
SQL
1 vote311 views1 answer
Sql check roles
SQL
0 vote173 views1 answer
Psql get table data types
SQL
3 votes166 views2 answers
Find the median in sql
SQL
4 votes219 views1 answer
Mysql query first character
SQL
1 vote165 views1 answer
Oracle sql create view
SQL
10 votes175 views1 answer
Oracle object dependencies
SQL