Home -> Usenet -> comp.databases.oracle -> Re: Finding the definition of a view

Re: Finding the definition of a view

From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1996/02/01
Message-ID: <DM3zKr.2wB_at_twisto.eng.hou.compaq.com>#1/1 







Daniel,


  Here is a list of the views to look up table and view information:



       user_views    - user owned views
       user_tables   - user owned tables
       all_views     - views the user has access to
       all_tables    - tables the user has access to
       dba_views     - all database views
       dba_tables    - all database tables





 The views dealing with view inforamtion includes the sql script used to 
create the view.  You will need to set long to around 10000 to display the 
entire sql statment.



D. Kim Hughes


Managing Consultant


DRT Systems


Houston, TX 


(713)868-5537
Received on Thu Feb 01 1996 - 00:00:00 CET












Original text of this message