+12 use SQL::Parser; +34 my $statement = "uPdate scott.emp set ename='SCT%',emp_date=TO_DATE('04/16/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'),empno='15645' WHERE dept=20 and ename IN(select ename from emp where empno='1111')"; +172 my $parser = SQL::Parser->new('AnyData', {RaiseError=>1} ); +173 $parser->parse($statement);