游标的小例子

MS SQLSERVER

 DECLARE @icno nvarchar(20), @date nvarchar(20);
 declare c1 cursor for select o.date_start,o.icno from OldStartDate o,CUSTMOER_ICNO c where o.icno=c.icno;

OPEN c1

while @@FETCH_STATUS = 0 
 begin
  FETCH NEXT FROM c1 INTO @date,@icno
  update CUSTMOER_ICNO set STARTDATE=@date where icno=@icno

END
 
CLOSE c1
DEALLOCATE c1
 

 

ORACLE：

DECLARE
  -- 定义游标.
  CURSOR C1 IS
    SELECT * FROM 表;

  XROW    表%ROWTYPE;
BEGIN
 .
  OPEN C1;
  LOOP
     FETCH C1 INTO XROW;
      Exit when C1%NOTFOUND;

      --修改操作
  
  END LOOP;
  CLOSE C1;
END;