Re: WHERE IN clause limitation
From: Michael A. Devito <mdevito_at_caduceus.chc.org>
Date: 1995/10/04
Message-ID: <mdevito.32.0016EE80_at_caduceus.chc.org>#1/1
Date: 1995/10/04
Message-ID: <mdevito.32.0016EE80_at_caduceus.chc.org>#1/1
In article <44i6ho$cll_at_hpcc48.corp.hp.com> khare_at_corp.hp.com (Vilas Khare) writes:
>From: khare_at_corp.hp.com (Vilas Khare)
>Subject: WHERE IN clause limitation
>Date: 30 Sep 1995 01:29:28 GMT
>Oracle V 7.1.x has a limitation in the "WHERE IN" clause. I can't handle
>more than 255 elements.
...
How about using UNION and put each value in a separate SELECT? This would have the advantage of using an index if one is available.
Mike DeVito
mdevito_at_chc.org
Received on Wed Oct 04 1995 - 00:00:00 CET