Re: in () max expression list...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:46:22 +0800
Message-ID: <3797129E.2297@yahoo.com>

Jacqui Caren Jacqui Caren wrote:
>
> 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/

A simple test would be:

spool file.lst
select 'select * from my_table where col in (' from dual union all
select rownum||','
from all_objects;
spool off

this will give you a nice query with a thousands on things in the "in" list...you should be able to find an upper bound if one exists...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 22 1999 - 07:46:22 CDT