pl/sql cursor的用法

/*声明部分，以declare开头*/
declare
v_id integer;
v_name varchar(20);
cursor c_emp is select * from employee where emp_id=3;
/*执行部分，以begin开头*/
begin
　open c_emp;　　　　　　　　　　　　　--打开游标
　loop
　　fetch c_emp into v_id,v_name;　　--从游标取数据
　　exit when c_emp%notfound ;
　end loop ;
close c_emp;　　　　　　　　　　 --关闭游标
dbms_output.PUT_LINE(v_name);
/*异常处理部分，以exception开始*/
exception
　when no_data_found then
　　dbms_output.PUT_LINE('没有数据');
end ;

评论

1 楼 jakey0613 2009-04-09  

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




ALTER    FUNCTION [dbo].[csGetServiceTask] (@iSVC_SEQ varchar(20)) 
RETURNS varchar(4096) AS  
BEGIN 
  declare @cre_user varchar(20)
  declare @cre_time varchar(20)
  declare @svc_remark varchar(100)
  declare @fls_no varchar(3)
  declare @eqp_no varchar(10)
  declare @iCount int
  declare @sResult varchar(4096) 

  declare cursor1 cursor for
     select  CRE_USER, CRE_DATE + ' ' + CRE_TIME as CRE_TIME,IsNull(SVC_REMARK,'') SVC_REMARK,
      IsNull(FLS_NO,'') FLS_NO,IsNull(EQP_NO,'') EQP_NO from MIS_ServiceTask t
     where SVC_SEQ=@iSVC_SEQ
     order by TASK_SEQ

  open cursor1
  fetch next from cursor1 into @CRE_USER,@CRE_TIME,@SVC_REMARK,@FLS_NO,@EQP_NO

  set @iCount = 0
  set @sResult = ''
  while @@FETCH_STATUS=0 begin
    set @iCount = @iCount + 1
    set @sResult = @sResult + Cast(@iCount as varchar(5))+'.'+@CRE_USER+' '+
        @CRE_TIME +' '+Substring(@SVC_REMARK,1,30)+' '+@FLS_NO+' '+@EQP_NO+'<br>'
    fetch next from cursor1 into @CRE_USER,@CRE_TIME,@SVC_REMARK,@FLS_NO,@EQP_NO
  end

  close cursor1
  deallocate cursor1
  return @sResult
END




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

能帮我解释一下吗？谢谢！！