create or replace procedure name_pro
as
type t_var is varray(3) of varchar2(1);
v_var t_var:=t_var();
begin
for i in 1..3 loop
v_var.extend;
v_var(i):=i;
dbms_output.put_line(v_var(i));
end loop;
end;
/SQL> set serveroutput on
SQL>
SQL> begin
2 name_pro;
3 end;
4 /
1
2
3PL/SQL procedure successfully completed
as
type t_var is varray(3) of varchar2(1);
v_var t_var:=t_var();
begin
for i in 1..3 loop
v_var.extend;
v_var(i):=i;
dbms_output.put_line(v_var(i));
end loop;
end;
/SQL> set serveroutput on
SQL>
SQL> begin
2 name_pro;
3 end;
4 /
1
2
3PL/SQL procedure successfully completed
是否是固定格式
v_var t_var:=t_var();是分配空间还是其他?
v_var t_var:=t_var();--是初始化数组,没有元素