RE: IN operator

On Wed, 31 May 2000, Abdul Aleem wrote:
> Never thought that way, feel there isn't unless you get tired.
> However IN does support SELECT statement if that solves your purpose.
>
> i.e., WHERE EmpNo IN (SELECT EmpNo FROM .... WHERE )
>

That's very expensive. How about a simple join?

oli.

> Regards,
>
> Aleem
> -----Original Message-----
> From: H. KARTHIKEYAN
> [mailto:h.karthikeyan_at_tatainfotech.com]
> Sent: 31 May, 2000 3:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: IN operator
>
> 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
>
> --
> Author: Abdul Aleem
> INET: abchaudhary-ho_at_beaconhouse.edu.pk
>
> 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).

-- 
------------------------------------------------------------------------------
Oliver Artelt                                     Jordanstr.7, 39112 Magdeburg
mailto:oli_at_cubeoffice.de                    Tel: 0391-6112820 Fax: 0391-604243 
------------------------------------------------------------------------------
http://www.cubeoffice.de
------------------------------------------------------------------------------