Re: SQL deparser ?
- From: "Richard Ji" <richard.c.ji@xxxxxxxxx>
- To: bpolarsk@xxxxxxxxx
- Date: Thu, 18 May 2006 11:45:28 -0400
If you know Java, check out JavaCC (Java Compiler Compiler) and it
comes with a SQL grammer parser.
HTH
Richard Ji
On 5/18/06, Bernard Polarski <bpolarsk@xxxxxxxxx> wrote:
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.
--
http://www.freelists.org/webpage/oracle-l
- References:
- SQL deparser ?
- From: Bernard Polarski
Other related posts:
- » SQL deparser ?
- » Re: SQL deparser ?
- » Re: SQL deparser ?
- » Re: SQL deparser ?
- » RE: SQL deparser ?
- » Re: SQL deparser ?
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.
- SQL deparser ?
- From: Bernard Polarski