cursors with where in clause [message #423051] |
Mon, 21 September 2009 23:28  |
pradeepsakti
Messages: 37 Registered: May 2009
|
Member |

|
|
Hello all..
can anyone pls help me
1. How to use cursors if I get an array of numbers as input and I need to compare the array with where in.
2. Or is there anyway to get any number of inputs i.e. say less than 50 0nly but varied between 1-50 for a cursor and then compare them with WHERE IN clause??
typically I am looking for this
cursor(p_nums IN NUMEBR)
select * from emp
where id IN (p_nums);
Thanks alot in advance.
|
|
|
|