NEXT and PRIOR Table Attributes : Associative Arrays « Collections « Oracle PL/SQL Tutorial






SQL>
SQL> DECLARE
  2    TYPE t_MajorTable IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;
  3    v_Majors t_MajorTable;
  4    v_Index  BINARY_INTEGER;
  5  BEGIN
  6    -- Insert values into the table.
  7    v_Majors(-7) := 'A';
  8    v_Majors(4) := 'B';
  9    v_Majors(5) := 'C';
 10
 11    -- Loop over all the rows in the table, and insert them into
 12    -- temp_table.
 13    v_Index := v_Majors.FIRST;
 14    LOOP
 15      DBMS_OUTPUT.put_line(v_Index||' ' || v_Majors(v_Index));
 16      EXIT WHEN v_Index = v_Majors.LAST;
 17      v_Index := v_Majors.NEXT(v_Index);
 18    END LOOP;
 19  END;
 20  /
-7 A
4 B
5 C

PL/SQL procedure successfully completed.

SQL>








26.7.Associative Arrays
26.7.1.Associative Arrays demo
26.7.2.Associative arrays (index-by tables)
26.7.3.PL/SQL Table
26.7.4.Index by string
26.7.5.Nested Table with Table row elements inside
26.7.6.Assign value to PL/SQL table
26.7.7.TABLE.Exist
26.7.8.Clear the salaries table by assigning the empty version to it
26.7.9.Place some values into the salaries table
26.7.10.PL/SQL table of cursor
26.7.11.Select data into PL/SQL table of cursor
26.7.12.Use For loop to output data in a PL/SQL table of cursor
26.7.13.Use for all loop to loop through the PL/SQL table
26.7.14.Change PL/SQL table element by index
26.7.15.Insert data in PL/SQL table to a real table
26.7.16.The COUNT Table Attribute
26.7.17.Uses the COUNT method to display the number of rows contained in an index-by table
26.7.18.The DELETE Table Attribute
26.7.19.The EXISTS Table Attribute
26.7.20.FIRST and LAST Table Attributes
26.7.21.NEXT and PRIOR Table Attributes
26.7.22.Using INDEX BY BINARY_INTEGER
26.7.23.Indexing Associative Arrays