ORA-01795: maximum number of expressions in a list is 1000
01795. 00000 - "maximum number of expressions in a list is 1000"
*Cause: Number of expressions in the query exceeded than 1000.
Note that unused column/expressions are also counted
Maximum number of expressions that are allowed is 1000.
*Action: Reduce the number of expressions in the list and resubmit.
Error at Line: 1,002 Column: 1
This is one of the differences between SQL server (management studio) and Oracle (Oracle SQL developer). It is especially problematic when I have a list of values in where statement. Use SQL server whenever possible.
