Re: determine tables in view (9iR2)

• EXPLAIN PLAN SET STATEMENT_ID = xyz FOR select * from <view-name>;
  
• select OBJECT_OWNER, OBJECT_NAME from PLAN_TABLE where STATEMENT_ID = xyz and OBJECT_TYPE = 'TABLE';
  

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