Archive for the ‘SQL’ Category

If you run into the error “ORA-01795 maximum number of expressions in a list is 1000”, you’ll probably created a query that has to many elements in the IN-clause. To fix it, use the provided helper class to issue multiple queries with less than 1000 elements.


top