Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - long list in the where clause. Any ideas?

Re: SQL - long list in the where clause. Any ideas?

From: Dale Edgar <Dale_at_DataBee.com>
Date: Tue, 4 Feb 2003 08:20:22 +0000 (UTC)
Message-ID: <3e3f7791.320679192@news.btclick.com>


On 31 Jan 2003 13:06:59 -0600, anon_at_anon.com (dev) wrote:

>I now have a requirement that may cause this list to be huge. Oracle
>has a limitation of 2000 items in an IN statement. I have tried using
>many OR statements but perfomrance is terrible.

Just as an aside, the number is actually considerably less (approx 256) on early versions of Oracle 8 and all of Oracle 7.

-Dale



DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com Received on Tue Feb 04 2003 - 02:20:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US