Re: How to do with it?

How about this? It might help you even if I made typoes ;)

declare
  cursor c1 is
    select name from test;
begin
  for temp in c1 loop
    dbms_output.put(temp.name || ' ');
  end loop;
  dbms_output.new_line;
end;

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:27:42 CDT