Consder the following sql
select somefields
from atable
where afield in (somelist)
In Oracle, there is a limit on the number of items somelist
can contain. In 9i for example, the limit is 1000.
Has anyone come across a limit for query of queries? I've
successfully run queries where the list had roughly 1500 items in
it, so if there is a limit, I know it's higher than tha.