| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need your help!!!
Try either one of the following:
select referenced_name, referenced_type
from dba_dependencies
where owner='<view_owner>' and
name='<view_name>' and
type='VIEW';
set long 2000000000
select text from dba_views
where owner='<view_owner>' and
view_name='<view_name>';
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Ngo, Tan" <TNGO_at_eftia.com>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 6/27/00 9:39:35 PM
>
Question: Is there a table/view that I can query to find out
the reference
>tables from a view?
>What I meant here is: I have a view which comprises more than
one table. I
>need a way to find out which table(s) this view is buildt upon.
If you have
>script to do this, I appreciate very much. Could you help ASAP
>
>Tan Ngo
>Database Specialist
>Direct Line (613)368-4151
>Cell. (613)286-0033
>e-mail: tngo_at_eftia.com <mailto:tngo_at_eftia.com>
>
>
 |
 |