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 🙂