Re: long "IN" list, tempo in-memory table

Hi:

If you're using Oracle8.1, you can create a temporary table and insert the necessary values into it. Then, SELECT * FROM mytable WHERE myvalue IN (SELECT myvalue FROM temptable);

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Fei Sha wrote in message <3799FE7D.76F0E296_at_prism.uvsq.fr>...
>Hi,
>
> I want to do a SQL query but dont know how to, please help!
>
> What i'd like to do is a query like this:
>
> SELECT *
> FROM mytable
> WHERE
> myvalue IN (v1,v2,v3,......);
>
> The problem is that in ther "IN" list, one can not give more than
> 256 values. But I need absolutely specify more than 256 values.
>
> Can I create an in-momory temporary table then use it? If yes how
>to?
>
> If no, is there other *efficient* ways to have the query done?
>
>Thanks a lot!
>
>Fei
>
>
>
Received on Mon Jul 26 1999 - 21:27:31 CDT