Oracle Error ORA-01795: maximum number of expressions in a list is 1000

Oracle Error Message

ORA-01795: maximum number of expressions in a list is 1000

Reason for the Error

Number of expressions in the query exceeded than 1000. Note that unused column/expressions are also counted Maximum number of expressions that are allowed are 1000.

Solution

Reduce the number of expressions in the list and resubmit.