Limits with IN operator Are there any upper limits on the amount of terms that could be between the parenthesis on an IN operator?

For example, the query would look something like:

SELECT * FROM table WHERE number IN (1,2,3...n)


I'm curious if there's any upper limit for 'n'.
You mean the IN operator. There are limits, but they differ from DB engine to engine.


SQL Server: 65,536 * Network Packet Size - see Batch Size
Oracle seems to allow 1,000.