re: determine tables in view (9iR2)

From: cosmin ioan <cosmini@xxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 9 Feb 2007 12:19:49 -0800 (PST)

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

Follow-Ups:

Re: determine tables in view (9iR2)
From: Tim Gorman

RE: determine tables in view (9iR2)
From: Jacques Kilchoer

Other related posts:

Browse oracle-l