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