If view exists, drop view : USER_VIEWS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_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.

   
    
  

Related examples in the same category