cursor_loop

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;