Assign value to PL/SQL table : Associative Arrays « Collections « Oracle PL/SQL Tutorial





SQL>
SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
  2      --Define an index-by table type.
  3      TYPE num_table IS TABLE OF NUMBER
  4                     INDEX BY BINARY_INTEGER;
  5
  6      nums num_table;
  7      some_num NUMBER;
  8  BEGIN
  9      nums(10) := 11;
 10
 11      BEGIN
 12          some_num := nums(11);
 13      EXCEPTION
 14      WHEN NO_DATA_FOUND THEN
 15          DBMS_OUTPUT.PUT_LINE('Element 11 does not exist.');
 16      END;
 17
 18  END;
 19  /
Element 11 does not exist.

PL/SQL procedure successfully completed.










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