If you know Java, check out JavaCC (Java Compiler Compiler) and it comes with a SQL grammer parser.
HTH
Richard Ji
Hello lister,
I am wondering if anybody knows a resource for a procedure/program that will isolate predicates for a given SQL.
I am quite interrested in the work of Dan Tow (http://www.oreilly.com/catalog/sqltuning/) and SQL diagramming as a generic approache to tune SQL. However this method requests for an SQL of 20 tables and 50 joins to generate counts and ratio for each predicate and it is rapidily over the hundred SQL statement.
-- //www.freelists.org/webpage/oracle-l