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 vote304 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote332 views1 answer
What logs are available on RDS MySQL?
SQL
1 vote298 views1 answer
Mysql return text after a final full stop
SQL
0 vote322 views1 answer
SQL-Arten
SQL
6 votes305 views3 answers
Update with inner join postgres
SQL
0 vote238 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote303 views1 answer
Oracle turn off constraint
SQL
0 vote293 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes297 views1 answer
How to show the whole table in sql
SQL
0 vote288 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL