Not sure if this is ontopic so I figure I would ask here and if its not liked then we can close it.
Our hosting provider for a legacy application that I inherited is no longer supporting Oracle 10 and are requiring us to move to Oracle 11g. I didn't think this would be a problem until nearly half of the SQL queries started failing. Upon research I found that previous versions of Oracle had a bug that didn't throw an exception at malformed ANSI SQL queries, and that bug was fixed in 11g.
To make a long story short, the brilliant minds that came before me wrote some awful queries and only basic integration tests, and I now have a few weeks to fix about 1000 malformed queries or we are dead in the water.
I will literally set myself on fire if I have to manually fix all of these, and was wondering if you guys knew of some tools or techniques for hunting down these offending queries to make this slightly less painful. Perhaps a special code profiler, or even a brilliant regex that can help me locate column references without an alias?