xxxxxxxxxx
FOR record_name IN cursor_name
LOOP
statement1;
statement2;
. . .
END LOOP;
xxxxxxxxxx
BEGIN
DBMS_OUTPUT.put_line ('SQL (embedded) cursor for loop');
FOR rec IN (SELECT * FROM parts)
LOOP
DBMS_OUTPUT.put_line (rec.partname);
END LOOP;
END;
/