/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 vote324 views1 answer
Mysql find tables with column name
SQL
0 vote358 views1 answer
Postgresql function ROUND
SQL
3 votes362 views2 answers
Postgres download
SQL
3 votes335 views2 answers
Having in mysql
SQL
0 vote348 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote347 views1 answer
Report in database
SQL
0 vote363 views1 answer
Count in sql and diff
SQL
2 votes398 views1 answer
Mysql select true or false
SQL
1 vote371 views1 answer
Psql view enum values
SQL
0 vote338 views1 answer
How to check default value of column in sql server
SQL