/SQL/Oracle create program if not exists

Oracle create program if not 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

1 vote247 views1 answer
Reutrn string after character sql
SQL
0 vote263 views1 answer
Mysql change timestamp on update
SQL
1 vote274 views1 answer
Mysql drop key
SQL
0 vote263 views1 answer
Mysql docker image arjun
SQL
0 vote293 views1 answer
Create table like sql
SQL
0 vote284 views1 answer
.sql File Run in PSQL
SQL
4 votes260 views3 answers
Order by value mysql
SQL
0 vote237 views1 answer
Postgres create database if not exists
SQL
3 votes280 views3 answers
Mysql declare variable
SQL
0 vote294 views1 answer
Disable database droping sql
SQL