create force view : Create View « View « Oracle PL / SQL






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>

   
    
  








Related examples in the same category

1.Create or replace a view
2.Create view without indiating the column name
3.Create OR REPLACE VIEW from selected columns in a table
4.Create a simple view
5.create materialized view
6.Create a view with check option
7.Create view by join three tables
8.Create view on single field of a type
9.Using view to simplify the query
10.User view and object id
11.Use view based on user-defind type