Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Maximum expressions inside a list - Oracle 8i
Shafeek Khalidh wrote:
> I've the following solutions
>
> 1) If this values inside the "IN" clause is from a table, we can JOIN. (Here
> it is not from a single table :-( )
>
> 2) I can create a table and put this data in that table and then select it
> using the following query
> "Select id from mytable where in EXISTS (select distinct id from
> anothertable where condition)". I'm keeping this as the last resort.
>
> Is there any other solutions?
>
> Shafeek Khalidh
>
>
an obvious one:
when U have more than 1000 values, use more than one "IN"-clause
...
where
col in (v1, v2, ... v1000)
or
col in (v1001, v1002, ...)
...
Matthias Received on Mon Jan 20 2003 - 04:11:28 CST