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 vote157 views1 answer
Postgresql delete limit
SQL
0 vote173 views2 answers
Drop tables from local table database postgres
SQL
1 vote146 views1 answer
Mysql best tutorial for beginners
SQL
17 votes195 views6 answers
Get last record in sql
SQL
0 vote92 views1 answer
Copy table dbeaver
SQL
1 vote148 views1 answer
Python escape mysql
SQL
1 vote151 views1 answer
Mariadb alter user host
SQL
9 votes163 views2 answers
Sql limit to 5 results
SQL
0 vote168 views1 answer
Postgresql import data from csv
SQL
2 votes162 views1 answer
Import large .sql files into lampp
SQL