LAST v16

Suggest edits

LAST is a method that returns the subscript of the last element in a collection.

Syntax

The syntax for using LAST is as follows:

<collection>.LAST

Where collection is the name of a collection.

Example

This example displays the last element of the associative array:

DECLARE
    TYPE sparse_arr_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
    sparse_arr      sparse_arr_typ;
BEGIN
    sparse_arr(-100)  := -100;
    sparse_arr(-10)   := -10;
    sparse_arr(0)     := 0;
    sparse_arr(10)    := 10;
    sparse_arr(100)   := 100;
    DBMS_OUTPUT.PUT_LINE('LAST element: ' || sparse_arr(sparse_arr.LAST));
END;

LAST element: 100
← Prev

FIRST

↑ Up

Collection methods

Next →

LIMIT