oracle create program if not exists

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

Search
showing results for - "oracle create program if not exists"
Julie
08 Jul 2020
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 existsoracle sql create or replace viewif not null pl sql oracleoracle drop type if existsoracle error compilation lineoracle change expired password sql developeroracle drop sequence if existsoracle create job if not existsxamarin sql lite create table if not existcreate sequence if not exists postgresoracle create synonymoracle error linecheck if table exists oracleoracle create programoracle v 24parameter does not existoracle create index if not existsdrop table if exists oracle
queries leading to this page
oracle create program if no existsoracle create program if not existsoracle create program if not exists