Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> re: determine tables in view (9iR2)
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-lReceived on Fri Feb 09 2007 - 14:19:49 CST
![]() |
![]() |