Re: IN operator

From: Venugopal V V S <venug_at_cse.iitb.ernet.in>
Date: Wed, 31 May 2000 16:04:26 +0530 (IST)
Message-Id: <10514.107235@fatcity.com>

Strange..What's the err.code?

---

Venu Gopal VVS.
Software Engineer.
Project SMARS.
Dept. of Comp. Sc. & Engg.
IIT Bombay, Powai
Mumbai, INDIA, 4000076
Lab.Phone.5782545 X 8913
Direct Ph. 5768703
Tansa Room# 331 Ph.5612                  

		URL         http://venug.8m.com/index.htm
                Resume      http://venug.8m.com/resume.htm
_____________________________________________________________________________

On Wed, 31 May 2000, H. KARTHIKEYAN wrote:

> Hi all
>
> I would like to know is there any restriction in IN list(like no. of
> expression)?.
>
> select * from temp where a in (1,2,...1001);
>
> It gave an error .
>
> Is there any restriction ?.
>
> TIA
>
> **************************************
> 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
> **************************************
>
> --
> Author: H. KARTHIKEYAN
> INET: h.karthikeyan_at_tatainfotech.com
>
> 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 - 05:34:26 CDT