Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

If view exists, drop view

SQL> SQL> BEGIN   2    FOR i IN (SELECT null FROM user_views WHERE view_name = 'BOOKS_emp') LOOP   3      EXECUTE IMMEDIATE 'DROP VIEW books_emp';   4    END LOOP;   5  END;   6  / PL/SQL procedure successfully completed.