Re: Number of elements in "IN operator"

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 11 Aug 2003 10:58:17 -0700
Message-ID: <4b5394b2.0308110958.37f9335_at_posting.google.com>


mikhailitchenko_at_hotmail.com (Mikhail) wrote in message news:<517cd21f.0308110644.59519749_at_posting.google.com>...
> Hi ,
>
> Does anybody know -how many elements could be in SQL operator IN?.
>
> As an example DELETE FROM emp WHERE ename IN (NULL, 'king',...,N);
>
> Thank you in advance .

The SQL standard does not list a limit.

You don't memtion what version of ORACLE you use, though I doubt the limit has changed much if any. I don't know what the limit is for ORACLE, but you could put together a quick test to find out.

Lastly, you do know that the NULL in the above example will not work, right? Received on Mon Aug 11 2003 - 19:58:17 CEST

Original text of this message