Number Table by BINARY_INTEGER
SQL> SQL> set serveroutput on SQL> SQL> DECLARE 2 TYPE NumberTab IS TABLE OF NUMBER 3 INDEX BY BINARY_INTEGER; 4 v_Numbers NumberTab; 5 BEGIN 6 FOR v_Count IN 1..10 LOOP 7 v_Numbers(v_Count) := v_Count * 10; 8 END LOOP; 9 10 DBMS_OUTPUT.PUT_LINE('Table elements: '); 11 FOR v_Count IN 1..10 LOOP 12 DBMS_OUTPUT.PUT_LINE(' v_Numbers(' || v_Count || '): ' || 13 v_Numbers(v_Count)); 14 END LOOP; 15 16 BEGIN 17 DBMS_OUTPUT.PUT_LINE('v_Numbers(11): ' || v_Numbers(11)); 18 EXCEPTION 19 WHEN NO_DATA_FOUND THEN 20 DBMS_OUTPUT.PUT_LINE( 21 'No data found reading v_Numbers(11)!'); 22 END; 23 END; 24 / Table elements: v_Numbers(1): 10 v_Numbers(2): 20 v_Numbers(3): 30 v_Numbers(4): 40 v_Numbers(5): 50 v_Numbers(6): 60 v_Numbers(7): 70 v_Numbers(8): 80 v_Numbers(9): 90 v_Numbers(10): 100 No data found reading v_Numbers(11)! PL/SQL procedure successfully completed. SQL> SQL> SQL>