pl/sql二维数组的使用

直接上例子

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

运行结果：

显示二维数组所有元素
58
100
102
55
6
73
2
4

1

 

1

显示二维数组所有元素

2

58

3

100

4

102

5

55

6

6

7

73

8

2

9

4