declare
TYPE h IS RECORD (
name1 VARCHAR2(32), /* 名1 */
name2 VARCHAR2(32), /* 名2 */
name3 VARCHAR2(32), /* 名3 */
.
.
.
name100 VARCHAR2(32), /* 名100 */
);
type t is varray(100) of h;
v t:=t();
begin
for i in 1..100 loop
v.extend;
dbms_output.put_line(v(i));
end loop;
end;
/
TYPE h IS RECORD (
name1 VARCHAR2(32), /* 名1 */
name2 VARCHAR2(32), /* 名2 */
name3 VARCHAR2(32), /* 名3 */
.
.
.
name100 VARCHAR2(32), /* 名100 */
);
type t is varray(100) of h;
v t:=t();
begin
for i in 1..100 loop
v.extend;
dbms_output.put_line(v(i));
end loop;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货