Oracle的一个函数例子
declare
cursor v_cur is select * from tuserinfo where rownum<30;
v_row tuserinfo%rowtype;
var_sql varchar2(2000);
begin
open v_cur;
loop
fetch v_cur into v_row;
exit when v_cur%notfound;
--dbms_output.put_line('id:'||v_row.userno||' name:'||v_row.mobileid);
var_sql := var_sql||'id:'||v_row.userno||';name:'||v_row.mobileid||'|';
end loop;
dbms_output.put_line(var_sql);
close v_cur;
end;