OCI-63813
Incorrect syntax in IN clause using table value constructor
Cause
Table value constructors in the IN clause should use comma separated values. For example: select employee_id, first_name, last_name from employees where employee_id in ( values (100), (101), (102) );
Should be specified as select employee_id, first_name, last_name from employees where employee_id in ( values (100, 101, 102) );
Action
For a single value IN LIST, use comma separated values without parenthesis.