Re: How to do with it?

From: <mashy_at_null.net>
Date: Wed, 26 Aug 1998 13:28:30 GMT
Message-ID: <6s12hv$4if$1@nnrp1.dejanews.com>

See if this is what u are after ....

declare

vc_name varchar2(2000) ;
cursor c1 is

       select name
       from   test ;
 begin
     vc_name := '';
     for i in c1
     loop
        vc_name := vc_name||' '||i.name ;
     end loop;
     dbms_output.put_line(vc_name);

end;

Regards !

Mashya

In article <35f069fd.7664475_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 08:28:30 CDT