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>


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

Original text of this message