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.
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