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/