[antlr-interest] Newbie needs guidance on parsing SQL

WALTERS, CRAIG P [AG/1000] craig.p.walters at monsanto.com
Wed Sep 20 09:53:30 PDT 2006


I am doing my 1st antlr project (version 2.7.6).  I downloaded DmlSQL2/SQL2
and converted them from C++ to Java.  What I need to do is scan a string
containing (Oracle) SQL DML and extract all of the names of the tables that
are the targets of modifications (INSERT, UPDATE, DELETE, TRUNCATE).  I
can't figure out how to get the table names.  Can someone give me some
suggestions?

Craig

---------------------------------------------------------------------------------------------------------
This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.


All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware". Monsanto accepts no liability for any damage caused by any such code transmitted by or accompanying this e-mail or any attachment.
---------------------------------------------------------------------------------------------------------



More information about the antlr-interest mailing list