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.