A script-enabled browser is required for this page to function properly.

GO_RECORD Built-in

Description

Navigates to the record with the specified record number.

Syntax

PROCEDURE GO_RECORD
(record_number NUMBER);

Built-in Type restricted procedure

Enter Query Mode no

Parameters

record_number Specifies any integer value that PL/SQL can evaluate to a number. This includes values derived from calls to system variables, such as TO_NUMBER(:SYSTEM.TRIGGER_RECORD) + 8.

GO_RECORD Restrictions

GO_RECORD Examples

/*

** Built-in: GO_RECORD
** Example: Navigate to a record in the current block
** by record number. Also see FIRST_RECORD and
** LAST_RECORD Built-ins.
*/
BEGIN
Go_Record( :control.last_record_number );
END;