|
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>
|