The COUNT Table Attribute : Associative Arrays « Collections « Oracle PL/SQL Tutorial

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

SQL>
SQL> DECLARE
  2    TYPE t_NumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  3    v_Numbers t_NumberTable;
  4    v_Total NUMBER;
  5  BEGIN
  6    -- Insert 50 rows into the table.
  7    FOR v_Counter IN 1..50 LOOP
  8      v_Numbers(v_Counter) := v_Counter;
  9    END LOOP;
 10
 11    v_Total := v_Numbers.COUNT;
 12  END;
 13  /

PL/SQL procedure successfully completed.

SQL>
SQL>