Re: How to do with it?

From: Jan D. Smit <jds_at_sba.nl>
Date: Wed, 26 Aug 1998 17:29:21 +0200
Message-ID: <6s18q5$t5p$1@news.Eindhoven.NL.net>

Oops... I forgot something...
Start with 'set serveroutput on'

Jan

Violin heeft geschreven in bericht
<35f276f6.10986646_at_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 Wed Aug 26 1998 - 10:29:21 CDT