Re: in () max expression list...

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 25 Jul 1999 15:56:06 GMT
Message-ID: <7nfc2m$pr$1@news.seed.net.tw>

Jacqui Caren (Jacqui Caren) <Jacqui.Caren_at_ig.co.uk> wrote in message news:FF9zD5.Gw8_at_ig.co.uk...
> 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?

In the "Expressions" section, Chapter 3 (Chapter 5 in 8i) of Oracle8 SQL Reference, it says "An Expression list can contains up to 1000 expressions". Received on Sun Jul 25 1999 - 10:56:06 CDT