RE: Need your help!!!

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Tue, 27 Jun 2000 18:27:55 -0500
Message-Id: <10541.110604@fatcity.com>

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