Collections Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Collections
  4. An example of declaring an Index-by table
SQL> DECLARE
  2    TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3    myTable num_tab;
  4  BEGIN
  5    /*Do some processing */
  6    null;
  7  END;
  8  /
PL/SQL procedure successfully completed.
SQL>