transmart/transmart-core-db — pull request #15 by forus (2014-11-12 13:22:08+00:00)
Title: Overcome ora max number of expression in a list

This class aimed to overcome oracle limitation on the number of items in IN clause:
Message: ORA-01795: maximum number of expressions in a list is 1000

This class constructs composite condition
Instead of making one condition
patient_num IN (1, 2, 3, ... 1200)
it chops list of items and join sub-conditions with OR operations
patient_num IN (1, 2, 3, ... 1000) OR patient_num IN (1001, 1002, 1003, ... 1200)