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 vote144 views1 answer
Select lowest values sql
SQL
58 votes316 views6 answers
Create new user in postgres
SQL
2 votes134 views2 answers
Sql first character
SQL
3 votes138 views4 answers
Truncate syntax in sql
SQL
0 vote134 views1 answer
Fast sql column count
SQL
16 votes170 views3 answers
Order by sql query
SQL
0 vote130 views1 answer
Online sql testing tool
SQL
25 votes139 views3 answers
How to use a database to see tables mysql
SQL
0 vote141 views2 answers
T SQl Checking Your Username
SQL
0 vote139 views1 answer
Sql where part of string match
SQL