cursor_loop
来源:互联网 发布:java类成员变量初始化 编辑:程序博客网 时间:2024/05/16 04:44
DECLARE
CURSOR XX IS
SELECT * FROM NOTEBOOK;
ROWINDEX VARCHAR2(30);
BEGIN
FOR ENTRYROW IN XX LOOP
ROWINDEX := (XX%ROWCOUNT);
UPDATE NOTEBOOK
SET USERNAME = 'USERNAME' || ENTRYROW.NID,
USEREMAIL = 'USERMAIL' || ENTRYROW.NID,
TITLE = 'TITLE' || ENTRYROW.NID,
CREATEDATE = SYSDATE,
CONTENT = 'CONTENT' || ENTRYROW.NID,
REPLY = 'REPLY' || ENTRYROW.NID
WHERE NID = ROWINDEX;
DBMS_OUTPUT.PUT_LINE(XX%ROWCOUNT);
END LOOP;
COMMIT;
END;
CURSOR XX IS
SELECT * FROM NOTEBOOK;
ROWINDEX VARCHAR2(30);
BEGIN
FOR ENTRYROW IN XX LOOP
ROWINDEX := (XX%ROWCOUNT);
UPDATE NOTEBOOK
SET USERNAME = 'USERNAME' || ENTRYROW.NID,
USEREMAIL = 'USERMAIL' || ENTRYROW.NID,
TITLE = 'TITLE' || ENTRYROW.NID,
CREATEDATE = SYSDATE,
CONTENT = 'CONTENT' || ENTRYROW.NID,
REPLY = 'REPLY' || ENTRYROW.NID
WHERE NID = ROWINDEX;
DBMS_OUTPUT.PUT_LINE(XX%ROWCOUNT);
END LOOP;
COMMIT;
END;