Oracle Error ORA-01470: In-list iteration does not support mixed operators

Oracle Error Message

ORA-01470: In-list iteration does not support mixed operators

Reason for the Error

Constants of different types are specified in an in-list.

Solution

Use constants of same type for in-lists.