Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Range condition in SQL statement.
There's a workaround for this limitation, though. You can do one select statement with 255 elements in the 'in' unioned with another query with 255 elements in the 'in'. Not sure what the limitation on how many unions is, though.
~bob
Sybrand Bakker wrote:
> 255
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
> <veraon_at_hotmail.com> schreef in berichtnieuws 8e4g1g$e7p$1_at_nnrp1.deja.com...
> > Hi,
> > Does anybody know about the restrictions on range condition in SQL
> > statement:
> > select * from emp where empid in(1,2,3).
> > How many values we can put into 'in(...)' ?
> > Thank you,
> > Vera.
Received on Wed Apr 26 2000 - 00:00:00 CDT