Cursor declares %ROWTYPE as loop index implicitly. It then opens a cursor, gets rows of values from the active set in fields of the record and shuts when all records are processed.
Ex :
FOR smp_rec IN C1 LOOP
totalsal = totalsal + smp_recsal;
ENDLOOP;​
