Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

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>