Have a look on CPAN, lotsa PERL modules to parse SQL
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).