In Oracle Forms, to check for the first record use System.Cursor_Record system variable and to check for the last record use System.Last_Record system variable. Below are the examples:
Check If First Record in Oracle Forms
System.Cursor_Record return the current number of record in Oracle Forms in char. Suppose you have a tabular database block, in which you have multiple records then use System.Cursor_Record to determine the current record number. Below is an example of determining the first record:
BEGIN IF :SYSTEM.Cursor_Record = '1' THEN MESSAGE ('At first record.'); END IF; END;
Check If the Last Record in Oracle Forms
Use System.Last_Record to check if the last record. System.Last_Record returns the char value TRUE or FALSE. Below is an example:
BEGIN IF :SYSTEM.LAST_RECORD = 'TRUE' THEN MESSAGE ('At last record.'); END IF; END;