直接上例子
set serveroutput on;declare type a_varray_type is varray(10) of int; type nal_varray_type is varray(10) of a_varray_type; data nal_varray_type := nal_varray_type( a_varray_type(58,100,102), a_varray_type(55,6,73), a_varray_type(2,4) );begin dbms_output.put_line('显示二维数组所有元素'); for i in 1..data.count loop for j in 1..data(i).count loop dbms_output.put_line(data(i)(j)); end loop; end loop;end;/
21
1
set serveroutput on;
2
declare
3
type a_varray_type is varray(10) of int;
4
type nal_varray_type is varray(10) of a_varray_type;
5
data nal_varray_type := nal_varray_type(
6
a_varray_type(58,100,102),
7
a_varray_type(55,6,73),
8
a_varray_type(2,4)
9
);
10
begin
11
dbms_output.put_line('显示二维数组所有元素');
12
for i in 1..data.count
13
loop
14
for j in 1..data(i).count
15
loop
16
dbms_output.put_line(data(i)(j));
17
end loop;
18
end loop;
19
end;
20
/
21
运行结果:
显示二维数组所有元素581001025567324
1
1
显示二维数组所有元素
2
58
3
100
4
102
5
55
6
6
7
73
8
2
9
4