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 list of where condition using in a cursor

Re: IN list of where condition using in a cursor

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 07 Feb 2003 06:17:37 +0100
Message-ID: <b9g64v0jan6aelpqma3thj8i5k98prk76d@4ax.com> 





On Thu, 06 Feb 2003 23:01:27 -0500, C Chang <cschang_at_maxinter.net>
wrote:



>tioned in Tom's aarticle from web

>site (AskTom) seems not quite proper. I really do not know what to do. 





The obvious answer is you need to use dynamic sql, or alternatively
put your IN values in a table and use that in your IN.






Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Thu Feb 06 2003 - 23:17:37 CST












Original text of this message













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