RAJA BALASUBRAMANIAN

Greenhorn
+ Follow
since Feb 13, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by RAJA BALASUBRAMANIAN

How to return a table and write it in a file in a pl/sql function?
can any one give me an idea about it?
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?
16 years ago
JSF