Oracle has a limit of 1000 items for its IN clause. Is there a similar limit in SOQL? The SF documentation on the IN clause does not mention any limit. To clarify the definition of an item, the following example has 2 items in its IN clause:
SELECT Name FROM Widget__c WHERE Name IN ('Ring', 'Flange')
- the above code was taken from the linked SF documentation.