用游标.
sql> set serveroutput on
sql>
delcare
cursor c is select name from user;
name user.user_name%type;
begin
open c;
loop
fetch c into name;
exit when c%notfound;
dbms_output.put_line(name);
end loop;
close c;
end;
sql> set serveroutput on
sql>
delcare
cursor c is select name from user;
name user.user_name%type;
begin
open c;
loop
fetch c into name;
exit when c%notfound;
dbms_output.put_line(name);
end loop;
close c;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货