/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

10 votes89 views3 answers
Join multiple tables sql
SQL
0 vote99 views1 answer
Sql server cannot create database diagram
SQL
0 vote100 views2 answers
Mysql on update current_timestamp
SQL
0 vote99 views1 answer
Wp_query raw sql
SQL
1 vote98 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote141 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote145 views1 answer
Mysql faster delete
SQL
2 votes120 views2 answers
Python escape string for sql
SQL
1 vote118 views1 answer
Oracle columns table
SQL
-2 votes171 views1 answer
How-to-remove-mysql-root-password
SQL