Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Accessing Nested Table elements

SQL> declare   2    Type numberTableType is TABLE OF NUMBER;   3    v_numarray numberTableType;   4  begin   5    v_numarray :=numberTableType(10,20,30,40);   6   7   8    dbms_output.put_line(to_char(v_numarray(1))||', '||to_char(v_numarray(2))||', '||to_char(v_numarray(3))||', '||to_char(v_numarray(4)));   9  10  11    v_numarray(4):=50;  12    dbms_output.put_line(to_char(v_numarray(1))||', '||to_char(v_numarray(2))||', '||to_char(v_numarray(3))||', '||to_char(v_numarray(4)));  13  end;  14  / 10, 20, 30, 40 10, 20, 30, 50 PL/SQL procedure successfully completed. SQL>