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,

Other related posts: