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;