Limit on IN clause ORA-01795

There is a limit of of values that can be specified for IN clause. The limit is 1000 expressions. In case you try to to write following query you can get ORA-01795

Select
 shogen_no,
 shogen_desc,
 disp_turn
 From
 shogen
 where
 shogen_no in ('one', 'two', 'three', ..........'more than thousand')

solution is quite simple you need to write many IN caluse

where
 shogen_no in ('one', 'two', 'three', ..., 'first thousand') or
 shogen_no in ('four', 'five', 'six', ..., 'another thousand') or ...

Have a fun 🙂

Tomasz

 

Leave a Reply

Your email address will not be published. Required fields are marked *