Re: SQL statement is to large, and creates a error

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 03 Nov 2005 19:40:31 +0100
Message-ID: <dkdl1j$ais$1@news6.zwoll1.ov.home.nl>

Maxim Demenko wrote:
> jimi_xyz_at_hotmail.com schrieb:
>

>> NOTE: There is about 1884 values within the IN () function. AND..

>
>

>>
>> Any help/ideas will do.
>>
>> Thanks Inadvance
>> Jimi
>>

>
> Maybe this helps
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#sthref2245
>
>
> <quote>
> A comma-delimited list of expressions can contain no more than 1000
> expressions. A comma-delimited list of sets of expressions can contain
> any number of sets, but each set can contain no more than 1000 expressions.
> </quote>
>
> Best regards
>
> Maxim

And with reason, I'd say.

Having 1000 (or more - as you have) elements in such an IN list triggers the thought you are missing a table that can be referenced through a foreign key.
More efficient than an IN list, too.

So, rethink the design.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Thu Nov 03 2005 - 12:40:31 CST