使用Table类型数据 支持: type record_type is record( field1 number, field2 varchar2(10));a_table record_type;a_table 就相当于二维数组
create t_varr1 is varray(10) of number; create t_varr2 is varray(10) of t_varr1;declare v_varr t_varr2:=t_varr2(); begin for i in 1..10 loop for j in 1..10 loop v_varr.extend; v_varr(i)(j):=i+j; dbms_output.put_line(v_varr(i)(j)); end loop; end loop; end; /
to beckhambobo(beckham) 代码[ v_varr(i)(j):=i+j; ]在 运行的时候出现错误 号码是6531这样如何解决阿!!!!!!!!!!
支持:
type record_type is record(
field1 number,
field2 varchar2(10));a_table record_type;a_table 就相当于二维数组
create t_varr2 is varray(10) of t_varr1;declare
v_varr t_varr2:=t_varr2();
begin
for i in 1..10 loop
for j in 1..10 loop
v_varr.extend;
v_varr(i)(j):=i+j;
dbms_output.put_line(v_varr(i)(j));
end loop;
end loop;
end;
/
代码[ v_varr(i)(j):=i+j; ]在 运行的时候出现错误
号码是6531这样如何解决阿!!!!!!!!!!