Anyone heard of a utility that can be used to parse complex, nested SQL statements and return a list of source table.column elements? By source table.column elements I mean original table names in cases where an alias is used (<alias>column) or when no table name is supplied and a default table name is assumed. I know there are 3rd party SQL parsers that build a tokenized parse tree. But the effort to walk the trees generated by nested SQL statements in order to determine source table.column names seems significant. Motivation: I'm documenting a very complicated Oracle application and would like to track which table.column elements are being used across scripts. Thanks, Malcolm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
