Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Maximum expressions inside a list - Oracle 8i
Vladimir M. Zakharychev wrote:
> Create a view for the inlist. In that view, do your joins or literals or whatever.
> In the query, use IN (SELECT * FROM MyView). Another option would be to
> declare a nested table type, a function that populates and returns such nested
> table, and SELECT * FROM TABLE(CAST(MyFunction AS MyNTType)) in the
> inlist. Having over 1000 *literals* in an inlist sounds completely weird to me.
> It's just not the way the IN() is supposed to be used...
>
> --
Exactly my feelings. Put the values in a table, and join.
Frank Received on Wed Jan 22 2003 - 15:19:16 CST