Hi all,
I need to perform an analysis of a collection of SQL scripts to analyze usage of tables and possibly fields of a data warehouse. Does anyone have ideas of where I should look for a parsing routine that would pull out the various "selectable" objects from sql queries? Some of the queries will have pretty complicated and nested logic. The queries are all oracle-based. I could potentially use a dictionary approach, but I would rather not maintain a dictionary and instead just parse the SQL.
Thanks!