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 closeswhen all the records have been processed.      eg. FOR emp_rec IN C1 LOOP          salary_total := salary_total +emp_rec sal;         ...

vasu

• Oct 20th, 2012

Cursor for loop is the one by using this we need not to perform open, close, fetch operations of a cursor..

PRADEEP

• Oct 17th, 2012

If we use explicit cursor we need to open the cursor and fetching the data and close the cursor.

If we use cursor for loop cursor will open the cursor and fetching data and close the cursor automatically.

Answer Question  Select Best Answer