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
Other related posts:
