- or download this
uPdate scott.emp
set ename='SCT%',emp_date=TO_DATE('04/16/2011 00:00:00', 'MM/DD/YYYY H
+H24:MI:SS'),empno='15645'
WHERE dept=20 and ename IN(select ename from emp where empno='1111');
- or download this
Incomplete SET clause! at ./post_audit.pl line 173
Incomplete SET clause! at ./post_audit.pl line 173
- or download this
+12 use SQL::Parser;
...
+172 my $parser = SQL::Parser->new('AnyData', {RaiseError=>1} )
+;
+173 $parser->parse($statement);
- or download this
sub SET_CLAUSE_LIST
{
...
return undef unless ( $self->LITERAL_LIST( join ',', @vals ) );
return 1;
}