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...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message
news:b0gk2t$ov6b7$1_at_ID-137434.news.dfncis.de...
> Thanks alot Matthias, that's logical thinking. :-)
> I've applied that.
>
> Shafeek Khalidh
>
>
Received on Mon Jan 20 2003 - 08:59:33 CST
