Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "in" clause using binds / oo4o / asp

Re: "in" clause using binds / oo4o / asp

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 03 Feb 2004 13:36:47 GMT
Message-ID: <PtNTb.209118$I06.2316754@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.




Jim
Received on Tue Feb 03 2004 - 07:36:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US