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

1. Oracle PL/SQL Tutorial
2. Collections
3. Associative Arrays

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.