This is a Java SQL parser: http://www.experlog.com/gibello/zql/ Good luck, Chris ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Adi Hirschtein Sent: Monday, 25 September 2006 7:48 p.m. To: oracle-l@xxxxxxxxxxxxx Subject: sql parser for oracle Hi Guys, Does anyone know where I can find sql parser? I don't mind if it will be an oracle solution or something outside the db like java/c++ code or any other language. Generally, I need to take sql statements and to parse them to small pieces (e.g. taking out the columns ,tables ,where clause and etc). Thanks, Adi