"John" <Nothanks_at_noaddress.com> wrote in message
news:Xns94848C89B2C5ENothanksnoaddresscom_at_127.0.0.1...
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in
> news:PtNTb.209118$I06.2316754_at_attbi_s01:
> > "John" <Nothanks_at_noaddress.com> wrote in message
> > news:Xns948488D28205BNothanksnoaddresscom_at_127.0.0.1...
> >> Is it possible?
> >>
> >> seems to be quite a negative vibe :)
> >>
> >> Oracle 8.1.7.latest SE ideally!
> >>
> >> Thanks
> > Yes, why would it not be?
> > select ... from ... where x in (:hvone,:hvtwo,:hvthree); for 3 elements
> >
> > This won't work
> >:hvone='a,b,c'
> > select ... from ... where x in (:hvone); as an equivalent to above.
>
> Perhaps I needed to state that the amount of values in the "IN" is
unknown.
> Hence I want to pass in an array, not a list of binds.
>
> Cheers
Look at asktom.oracle.com and search for varying elements in in list
Jim
Received on Tue Feb 03 2004 - 08:01:49 CST
