Oracle create program if no 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 vote278 views1 answer
Print boolean in plsql
SQL
0 vote261 views1 answer
Sql server remove enter from string
SQL
0 vote254 views1 answer
Get employees if not contains in sql
SQL
0 vote285 views1 answer
How to update date value in sql
SQL
0 vote269 views1 answer
Mysql select inside sum
SQL
0 vote265 views1 answer
Mysql dump everythign
SQL
0 vote283 views1 answer
Mysql last friday of current month
SQL
1 vote277 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes259 views1 answer
Oracle drop table free up space
SQL
0 vote228 views1 answer
Delete all rows from table sqlite
SQL