Re: sql parser for oracle

Have a look on CPAN, lotsa PERL modules to parse SQL

http://search.cpan.org/search?query=sql&mode=all

Stefan

On 9/25/06, Adi Hirschtein <adi@xxxxxxxxxxxxx> wrote:


 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