Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Range condition in SQL statement.
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:956680365.12496.0.pluto.d4ee154e_at_news.demon.nl...
> 255
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
This number is the same as the number for max columns in a table.
254 in Oracle 7, 1000 in Oracle 8.
You can find the number in the SQL Reference Manual in Oracle 7.3 and 8.0.x.
By the way, the max number of components in the DECODE expression is 255.
> <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.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Thu Apr 27 2000 - 00:00:00 CDT