Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL deparser ?

Re: SQL deparser ?

From: Richard Ji <richard.c.ji_at_gmail.com>
Date: Thu, 18 May 2006 11:45:28 -0400
Message-ID: <b4d52f20605180845hd4d866cu87e88813016504cd@mail.gmail.com>


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_at_yahoo.com> 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
Received on Thu May 18 2006 - 10:45:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US