How to do with it?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Wed, 26 Aug 1998 02:45:39 GMT
Message-ID: <35f069fd.7664475@news.twsc.pouchen.com.tw>

Hello,
If I have a table with 3 rows:
NAME

---

This
is
test!

And I have a cursor:
DECLARE

      temp   CHAR(20); 
     Cursor C1 IS
          SELECT NAME FROM TEST;

And I open the cursor:
OPEN C1;
LOOP

      FETCH C1 INTO temp;
      EXIT WHEN C1%NOTFOUND;
/* I want to have the result : 'This is test!'.  */
      temp = ??

END LOOP; Please give some tips.
Best Regards.
Violin
violin.hsiao_at_mail.pouchen.com.tw Received on Tue Aug 25 1998 - 21:45:39 CDT