Query a view in user_objects table for a view just created : USER_OBJECTS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_OBJECTS

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>

   
    
    
  

Related examples in the same category