avr555
asked on
SQL Parsing algorithm
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?
And for this I need Paresing SQL statements and for this I need some algorithm.
Can anybody help me?
The book "lexx & yacc" (O'Reilly Press) has the complete code for an SQL parser.
ASKER
Have you ane URL to find this book in electronical view?
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.
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
There is also a Perl based SQL parser at http://www.cpan.org/modules/by-module/SQL/SQL-Statement-1.003.tar.gz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, I Need more theory about this.