Place some values into the salaries table : Associative Arrays « Collections « Oracle PL/SQL Tutorial

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

SQL>
SQL> SET SERVEROUTPUT ON
SQL> SET ECHO ON
SQL>
SQL> DECLARE
  2      TYPE myTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3
  4      salaries myTable;
  5      salaries_empty myTable;
  6  BEGIN
  7      
  8      salaries(20) := 50550;
  9      salaries(40) := 50550;
 10      salaries(60) := 50550;
 11
 12      salaries := salaries_empty;
 13  END;
 14  /

PL/SQL procedure successfully completed.

SQL>
SQL>