I need to write a simple query using oracle, java and mybatis:
select * from FOO foo where foo.id IN (ids)
select * from FOO foo where foo.id IN (chunk1) or foo.id IN (chunk2) ...
select * from FOO foo join SOME_TEMPORARY_ID tempids on foo.id = tempids.id
INTO some_table VALUES ('foo')
INTO some_table VALUES ('foo1')
INTO some_table VALUES ('foo2')
INTO some_table VALUES ('foo12345')
SELECT * FROM DUAL
Thanks that you describe your primary problem. Check, may be this can help you
where (foo.id, 0) in (('1', 0), ('2', 0),...)
This simple workaround hasn't limitation. If this answer wouldn't be appropriate then let me know. I delete this answer and think again at your child problem.