Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need your help!!!
Try TEXT from DBA_VIEWS
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com
-----Original Message-----
From: Ngo, Tan [mailto:TNGO_at_eftia.com]
Sent: Tuesday, June 27, 2000 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Need your help!!!
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>
Received on Tue Jun 27 2000 - 18:27:55 CDT