>> Just one simple doubt, Is there any limitation for EXISTS predicate too, as
>> we have for IN predicate for 1500 values ?

>No, because EXISTS is a different construct than IN, which does not
>expect a list of input values.

Moreover, as far as I know (may be wrong since I rarely use IN) the '1500 limitation' is only valid for statements like

IN (1, 2, 3, ..., 1499, 1500)

I'm pretty certain that you can use

IN (<subselect>)

without any limitation as to how many rows the subselect may return (well, at least the limit should be a lot higher than 1500).

Just wanted to clarify since your question a few days ago contained IN (<subselect>)

Set