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

Home -> Community -> Mailing Lists -> Oracle-L -> re: determine tables in view (9iR2)

re: determine tables in view (9iR2)

From: cosmin ioan <cosmini_at_bridge-tech.com>
Date: Fri, 9 Feb 2007 12:19:49 -0800 (PST)
Message-ID: <627866.91841.qm@web60420.mail.yahoo.com>


hi all,
  is there a (relatively) simple query or function to obtain all tables from a view, keeping in mind that that view can have many subviews which in turn could have many subviews etc etc (recursive func)    

  I don't want to re-invent the wheel nor write some funky long pl/sql, if something already exists out there ;-)    

  thx much,
  Cos

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 09 2007 - 14:19:49 CST

Original text of this message

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