oracle create program if no exists

Solutions on MaxInterview for oracle create program if no exists by the best coders in the world

Search
showing results for - "oracle create program if no exists"
Maria José
26 Oct 2019
1DECLARE
2    existing_program NUMBER;
3BEGIN
4    SELECT count(*) INTO existing_program
5    FROM ALL_SCHEDULER_PROGRAMS WHERE PROGRAM_NAME = 'prog_name' AND OWNER='owner';
6    IF existing_program = 1 THEN
7        dbms_scheduler.DROP_PROGRAM(PROGRAM_NAME => 'prog_name');
8    END IF;
9END;
10/
11BEGIN DBMS_SCHEDULER.create_program(program_name => 'owner.prog_name', ...); END;
similar questions
oracle merge insert if not existsoracle create table if not existsoracle drop job if existsoracle pl 2fsql check if file existsno data found oracleoracle no data found error codeoracle rename column if existsif not null pl sql oracleoracle drop type if existsoracle error compilation lineoracle drop sequence if existsoracle identify sql holding lockoracle create job if not existsxamarin sql lite create table if not existalter table add check constraint oracleoracle error linecheck if table exists oracleoracle create programoracle check table lockoracle v 24parameter does not existoracle create index if not existsoracle apex collection existsdrop table if exists oracle
queries leading to this page
oracle create program if no existsoracle create program if no exists