Show code of a cursor for loop. | PL SQL Interview Questions

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.
Eg:  FOR smp_rec IN C1 LOOP
totalsal=totalsal+smp_recsal;
ENDLOOP;

0 comments: