CREATE OR REPLACE PROCEDURE UPDATEDATA IS
CURSOR C_CUR IS SELECT SENSORID FROM XDSENSORINFO ORDER BY SENSORID,NAME;--创建游标
C_ROW C_CUR%ROWTYPE;
SEQU NUMBER;
BEGIN
FOR C_ROW IN C_CUR LOOP
SELECT SE.NEXTVAL INTO SEQU FROM DUAL;--获取序列的值
UPDATE XDSENSORINFO SET SORTNO = SEQU WHERE SENSORID = C_ROW.SENSORID;--更新数据
END LOOP;--使用for循环的方式遍历游标
END;
CURSOR C_CUR IS SELECT SENSORID FROM XDSENSORINFO ORDER BY SENSORID,NAME;--创建游标
C_ROW C_CUR%ROWTYPE;
SEQU NUMBER;
BEGIN
FOR C_ROW IN C_CUR LOOP
SELECT SE.NEXTVAL INTO SEQU FROM DUAL;--获取序列的值
UPDATE XDSENSORINFO SET SORTNO = SEQU WHERE SENSORID = C_ROW.SENSORID;--更新数据
END LOOP;--使用for循环的方式遍历游标
END;