All Forums Database
karteeky 7 posts Joined 02/11
13 Oct 2011
Object dependency



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.


venugopal2705 5 posts Joined 08/11
03 Nov 2011

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

You must sign in to leave a comment.