Last commandThe Last command moves the cursor to the last row in
the ResultSet, then fetches the row.Last commandCursorsfetching next row
The command displays a banner and the values of the row. The cursor must have
been created with the Get Scroll
Insensitive Cursor command.
SyntaxLAST IdentifierExampleij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> absolute 5 scrollCursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> last scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6