Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using IN predicate in PL/SQL
In article <a5lp3p$nmg$1_at_reader2.panix.com>, "R says...
>
>In PL/SQL I have constructed a variable (called v_Pool) with the value
>('ABC','DEF','GHI') to be used in the where clause of dynamic sql
>
>
>The following code does not work...please help
>
>if v_test IN v_Pool then
>........;
>end if;
>
>Also how do I specify v_Pool in a cursor
>
>cursor my_cur is
>select *
>from my_table
>where myfield IN ???
>
>Thanks
>
>
read
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:110612348061
...
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Thu Feb 28 2002 - 13:59:16 CST