create or replace
procedure test as
--申明数组类型
type t_test is table of varchar2(9);
test t_test:=t_test('A','B','C','D','E','F','G','H','J','K','L');
begin
--遍历数组,将遍历得到的数据插入到AA表中
for i in 1 .. test.count loop
--while循环
WHILE test(i)='A' loop
insert into AA(hongyan) values('AAAA');
END LOOP;
insert into AA(hongyan) values(test(i));
commit;
end loop;
end;
注意:数组的必须申明,oracle中的数组就是一张表;遍历数组的for条件;for循环中嵌入while循环