Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: IN operator

RE: IN operator

From: Miguel Urosa <murosa_at_smseuropa.com>
Date: Wed, 31 May 2000 13:10:13 +0200
Message-Id: <10514.107242@fatcity.com>

        What kind of error you get?

> -----Mensaje original-----
> De: H. KARTHIKEYAN [SMTP:h.karthikeyan_at_tatainfotech.com]
> Enviado el: mi=E9rcoles 31 de mayo de 2000 12:44
> Para: Multiple recipients of list ORACLE-L
> Asunto: IN operator

>=20

> Hi all
>=20

> I would like to know is there any restriction in IN list(like no. of
> expression)?.
>=20

> select * from temp where a in (1,2,...1001);
>=20

> It gave an error .
>=20

> Is there any restriction ?.
>=20

> TIA
>=20

> **************************************
> H.Karthikeyan
> Tata Infotech Ltd.,
> System Integration Division,
> 80 Feet Road, Indira Nagar, Bangalore.
> Ph: (80) 528 4681 (off) Ext: 423
> E-mail: h.karthikeyan_at_tatainfotech.com
> **************************************
>=20

> --=20
> Author: H. KARTHIKEYAN
> INET: h.karthikeyan_at_tatainfotech.com
>=20

> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 31 2000 - 06:10:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US