RE: IN operator

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 )

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 ?.