drop a backend table then query the view : Query View « View « Oracle PL / SQL






drop a backend table then query the view

 
SQL>
SQL>  create table t(
  2      id number,
  3      data varchar2(200) );

Table created.

SQL>
SQL>
SQL>  create or replace view view_t as
  2      select id view_id, data view_data
  3        from t;

View created.

SQL>
SQL>  drop table t;

Table dropped.

SQL>
SQL>  select * from view_t;
 select * from view_t
               *
ERROR at line 1:
ORA-04063: view "JAVA2S.VIEW_T" has errors


SQL>
SQL>
SQL>

 








Related examples in the same category

1.Querying data by selecting from the view runs the SELECT statement