How to process the loop and retrieve all the data's using cursor?
I have tried this code!
TYPE RECORD_VAR_NAME is table of FNR_DET%ROWTYPE;
FNR_REC RECORD_VAR_NAME;
BEGIN
OPEN FNR_DET;
LOOP
FETCH FNR_DET BULK COLLECT INTO FNR_REC;
EXIT WHEN FNR_REC.COUNT = 0;
END LOOP;
CLOSE FNR_DET;
END;
How to store the bulk result in a table?
Can any one help me out in this?