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 vote332 views1 answer
Sql grant select only
SQL
0 vote375 views2 answers
List all constraints in postgres
SQL
1 vote341 views1 answer
Postgres start database on linux
SQL
2 votes339 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
22 votes338 views3 answers
Join three tables sql
SQL
9 votes344 views6 answers
Check constraint in sql
SQL
1 vote371 views1 answer
Sqlalchemy on delete set null
SQL
0 vote363 views1 answer
Ceil upto 2 decimal place mysql
SQL
5 votes356 views2 answers
Get number of columns sql
SQL
5 votes383 views1 answer
Oracle source query
SQL