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