PLSQL Collection

From: simon <simon_at_simon.com>
Date: Tue, 14 Jun 2005 19:42:33 +0800
Message-ID: <42aec2a7$1_2@rain.i-cable.com>

I am new to PLSQL.

I declared an index by table:

DECLARE
    TYPE index_by_type IS TABLE OF NUMBER

        INDEX BY BINARY_INTEGER;
    index_by_table index_by_type;
BEGIN

    index_by_table(12):=...;
    index_by_table(2):=...;
    index_by_table(6):=...;
    index_by_table(8):=...;
    index_by_table.trim(2); /*so, which 2 are trimmed?*/

END; Now which elements are trimmed by the .trim() method? The method remove n elements from the end of the table. But how elements are sorted and which are considered the last n elements? Is it by ascending order of the index or by order in which the elements are created? Received on Tue Jun 14 2005 - 06:42:33 CDT