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