SQL> declare
2 TYPE varray_type IS VARRAY(50) OF VARCHAR2(10);
3 v1 varray_type;
4 begin
5 v1 := varray_type('hello','world');
6 for i in v1.first..v1.last loop
7 dbms_output.put_line(v1(i));
8 end loop;
9 end;
10 /
hello
world
PL/SQL procedure successfully completed
2 TYPE varray_type IS VARRAY(50) OF VARCHAR2(10);
3 v1 varray_type;
4 begin
5 v1 := varray_type('hello','world');
6 for i in v1.first..v1.last loop
7 dbms_output.put_line(v1(i));
8 end loop;
9 end;
10 /
hello
world
PL/SQL procedure successfully completed
转载于:https://blog.51cto.com/yerik/459604