Solved

SQL Parsing algorithm

Posted on 2002-03-06
6
774 Views
Last Modified: 2012-06-21
Now I try create some SQL builder.
And for this I need Paresing SQL statements and for this I need some algorithm.

Can anybody help me?
0
Comment
Question by:avr555
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:ct.smith
ID: 6844754
The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
0
 

Author Comment

by:avr555
ID: 6847182
Have you ane URL to find this book in electronical view?
0
 
LVL 4

Expert Comment

by:ct.smith
ID: 6848086
No, but its not all that expensive and relatively easy to find at bookstores.  It's also been around a while, so there's a chance that you may be able to borrowa copy from a library, friend, coworker, etc.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 19

Expert Comment

by:Kim Ryan
ID: 6851715
Of course the publisher will not give away their contents for free. But they do supply program code. Download http://examples.oreilly.com/lex/progs.zip and study sql1.y, sql2.y and sqltext.c

There is also a Perl based SQL parser at http://www.cpan.org/modules/by-module/SQL/SQL-Statement-1.003.tar.gz
0
 
LVL 19

Accepted Solution

by:
Kim Ryan earned 100 total points
ID: 6855868
0
 

Author Comment

by:avr555
ID: 6856820
Sorry, I Need more theory about this.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question