Hi,
I found this page (http://rwijk.blogspot.ca/2008/10/dbadependencycolumns.html) that shows on how to find columns used by any view (doesn’t work for view with inline function call). The page shows on how to create a custom view called "DBA_DEPENDENCIES_COLUMNS" which uses the column sys.dependency$.D_ATTRS in its logic.
There are some views that calls inline functions and those functions can call multiple other objects (table/views/function/procedure/...). How can we find all t columns used by a view of such (complex view)?
Does anyone have anything working solution or can point to me in the right direction to develop a logic that could work for us?
Thanks for reading and the attempt to help me,
Eric