Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query a view in user_objects table for a view just created

SQL> 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>  select object_name, status   2      from user_objects   3     where object_name = 'VIEW_T'; OBJECT_NAME                                                                                                              STATUS -------------------------------------------------------------------------------------------------------------------------------- ------- VIEW_T                                                                                                                   VALID SQL> SQL> SQL> drop table t; Table dropped. SQL>