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 vote262 views1 answer
Postgres add prefix to primary key
SQL
0 vote319 views1 answer
Query for backup a database at another location in file system
SQL
2 votes281 views1 answer
Possgress drop if exists table
SQL
0 vote276 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote291 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote320 views2 answers
Truncate table sqlite
SQL
3 votes282 views1 answer
Oracle get trigger ddl
SQL
1 vote282 views1 answer
Mysql best tutorial for beginners
SQL
46 votes340 views4 answers
Create column sql
SQL
0 vote344 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL