/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

3 votes136 views2 answers
Oracle sql drop sequence
SQL
0 vote172 views1 answer
Linux upload database to mysql
SQL
0 vote135 views3 answers
Java hide mysql login credentials
SQL
20 votes146 views5 answers
Reset auto increment mysql
SQL
1 vote134 views1 answer
Psql show with user is logged in
SQL
0 vote143 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
6 votes154 views2 answers
What is non relational database
SQL
3 votes135 views2 answers
Update Query in SQL Server
SQL
-2 votes146 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote148 views1 answer
Psql show db
SQL