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