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

2 votes338 views2 answers
Sql query to copy data from one column to another
SQL
0 vote332 views1 answer
Function plsql
SQL
0 vote267 views1 answer
Copy table dbeaver
SQL
5 votes322 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote372 views1 answer
Fetching data from mysqldb
SQL
1 vote369 views1 answer
Oracle transaction rollback not working
SQL
0 vote328 views1 answer
How to input data as id in database sql c#
SQL
0 vote331 views1 answer
Join creating duplicate columns sqllite
SQL
-1 vote329 views1 answer
Mysql order by on condition
SQL
4 votes322 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL