/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

0 vote214 views1 answer
Execut sql python
SQL
1 vote204 views1 answer
Oracle compile schema
SQL
0 vote196 views1 answer
Luu ckeditor vao mysql
SQL
0 vote225 views1 answer
T-sql email validation
SQL
1 vote210 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote217 views2 answers
Port 5432 is already in use mac
SQL
0 vote223 views1 answer
Insert value in identity
SQL
0 vote214 views2 answers
Postgres having
SQL
-1 vote211 views1 answer
How to create foreign key in sql server management studio
SQL
12 votes189 views5 answers
Sql primary key
SQL