Cursor for loop implicitly declares %ROWTYPE as loop index,opens a
cursor, fetches rows of values from active set into fields in the record
and closes when all the records have been processed.
eg. FOR emp_rec IN C1 LOOP
salary_total := salary_total +emp_rec sal;
END LOOP;