Object dependency

Database
Enthusiast

Object dependency

Hi,

How to get "View vs Table dependency" from dictionary tables by simple querying them? Query needs to list the table names  used by a View. It is possible in Oracle using dba_dependencies and similar table to get the list of tables used by a view. Please advice.

Karteek

Tags (3)
1 REPLY
Enthusiast

Re: Object dependency

I am not sure abt dependency even I am searching for that but you can use top down approach.....This wont work for bottom up approach

SHOW sel * from tablename