Re: in () max expression list...

In article <FEz0GL.98G_at_ig.co.uk>, Jacqui Caren <jacqui_at_ig.co.uk> wrote:
>
>I remember from the good ol' oracle7 days that
>you were limited to circa 256 entries with a
>
> fieldname IN ( ...)
>
>expression list.
>
>Having hunted through the vast quantity :-) of
>oracle docs I cannot find any references to the
>limit for oracle 8 but tests have shown that
>~350 entires seem to be no problem.

So does anyone have knowledge of the limit (if any) with and 08 server?

Jacqui
--
Paul Ingram Group Ltd,140A High Street,Godalming GU7 1AB United Kingdom Email: J.Caren_at_ig.co.uk Fax: +44 1483 419419 Phone: +44 1483 424424 A rather special Perl vacancy :-) http://www.ig.co.uk/about/jobs.html Use SmartCards in e-commerce systems? http://www.smartaxis.com/ Received on Thu Jul 22 1999 - 09:10:17 CDT