Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL deparser ?
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-lReceived on Thu May 18 2006 - 10:45:28 CDT
![]() |
![]() |