Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Determine underlying tables in a view

Determine underlying tables in a view

From: Sporge <RonGeorge_at_hotmail.com>
Date: 10 May 2004 00:46:15 -0700
Message-ID: <7e3b24c7.0405092346.799fa0e0@posting.google.com> 





Hi All



Is there any way to determine what the underlying tables are in a view
from within a stored procedure?



I've written a function that parses the View text but I was hoping for
something more elegant.



Any help in this regard would be appreciated.
Ron
Received on Mon May 10 2004 - 02:46:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US