Oracle for loop 循环

创建临时表

CREATE TABLE TMP(
ID NUMBER,
A VARCHAR(256)
)

写入测试数据

INSERT INTO TMP VALUES(1,'');
INSERT INTO TMP VALUES(2,'');
INSERT INTO TMP VALUES(3,'');
COMMIT;

通过循环修改

BEGIN
FOR DATA IN (SELECT ID FROM TMP) LOOP
  UPDATE TMP SET A = TO_CHAR(SYSDATE,'YYYYMMDD')
  WHERE ID = DATA.ID;
  COMMIT;
END LOOP;
END;