CREATE TYPE phone_type IS VARRAY(20) OF VARCHAR2(20); / CREATE TABLE employee( id NUMBER(4), name VARCHAR2(10), sal NUMBER(6,2), phone phone_type); /这个怎么插入数据?
看这个代码的例子,是否可以。declare type varchar2_varray1 is varray (3) of varchar2(5) not null ; --设定Not Null a varchar2_varray1:=varchar2_varray1(); type varchar2_varray2 is varray (3) of varchar2(5) ; --设定允许 Null b varchar2_varray2:=varchar2_varray2(‘A1’,'A2',Null); begin for i in a.count+1..a.limit loop a.extend; end loop; for i in 1..a.limit loop dbms_output.put_line('a('||i||')='||a(i)); end loop; for i in 1..b.limit loop dbms_output.put_line('b('||i||')='||b(i)); end loop; end;
type varchar2_varray1 is varray (3) of varchar2(5) not null ; --设定Not Null
a varchar2_varray1:=varchar2_varray1(); type varchar2_varray2 is varray (3) of varchar2(5) ; --设定允许 Null
b varchar2_varray2:=varchar2_varray2(‘A1’,'A2',Null);
begin
for i in a.count+1..a.limit loop
a.extend;
end loop;
for i in 1..a.limit loop
dbms_output.put_line('a('||i||')='||a(i));
end loop; for i in 1..b.limit loop
dbms_output.put_line('b('||i||')='||b(i));
end loop;
end;