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
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