Mega Code Archive

 

Categories / Oracle PLSQL / View

 

Create force view

SQL> SQL> SQL>  create view invalid_view as   2      select * from table_that_does_not_exist;     select * from table_that_does_not_exist                   * ERROR at line 2: ORA-00942: table or view does not exist SQL> SQL>  create force view invalid_view as   2      select * from table_that_does_not_exist; Warning: View created with compilation errors. SQL> SQL>  drop view invalid_view; View dropped. SQL> SQL>