Hi
i was stuck up in writing the logic in PL-SQL with cursors. i am writing the rough code below
Procedure xyz
select * from example
for I in c2 loop
....
....
cnt:=cnt+1
if count=30 then
logic to implement
.....
.....
endif
endloop
end xyz
I want to implement some logic to implement for all records of select statement but 30 at a time .
how to implement :
if it is <30, how to implement the logic in "if condition".
Also, if count is some 60, for frist 40 records the logic will implment but for rest 20 records, the condition (count=40) will not satisfy and will not go into logic
Kindly let me know if u need any more information
Thanks
madhavi