Suppose you want to scan a tabular grid block (loop through all records in detail block) from top to bottom in Oracle forms. You can do this task by using :system.last_record system variable to determine whether it is last record in a block and then exit.
--- then move to first record
--- do some processing
if :system.last_record = 'TRUE' then
--- after exiting move to top
Oracle Forms Recipes eBookDownload