Hi,
I have seen many times as first records are fetched using select statement and then they are manipulated and displayed using LOOP...ENDLOOP. and sometimes first LOOP...ENDLOOP is implemented and within it there exists a OPEN SQL statement to fetch the resultset to be manipulated or processed.
Which approach is widely used or what are the situations in which former and later approach is used.
Thanks and Regards
Ameet