I'm working on a project that has a homegrown ETL engine that processes SQL scripts stored in text files. I've counted over 40K lines of SQL code, about 99% uncommented. All the system's business logic is reflected in the SQL scripts themselves. We would like to overhaul this system.
Are there any utilities that could be used to analyze these SQL scripts similar to the way there are C and VB documentation generators, eg. generate a list of table and column names, constants, functions, frequency of use for the previous entities, etc? The scripts run against an Oracle 9 database but seem to be pretty generic SQL. One nuance is that many SELECTS are nested 4 levels deep which makes them difficult to understand. Recommendations? Thanks! Malcolm _______________________________________________ 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.
