Dynamically cursor ?
From: peter <misybh_at_tpts7.seed.net.tw>
Date: Fri, 20 Oct 2000 17:37:50 +0800
Message-ID: <8sp459$f4r_at_netnews.hinet.net>
Date: Fri, 20 Oct 2000 17:37:50 +0800
Message-ID: <8sp459$f4r_at_netnews.hinet.net>
Hello
[Quoted] I have a cursor which SQL-statement is as followong
cursor is
select A
from emp
where emp_no in(XXXXXXXX);
what I wish is that I can pass a string into XXXXXXX dynamically..
can I write this?
cursor is
select A
from emp
where emp_no in &v_string;
v_string:='('201','202','204');
????????
Received on Fri Oct 20 2000 - 11:37:50 CEST
