Oracle函数

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;