如果是1,2,3和1,2,3,4,5分别以整体的数据加到 table2中declare
v_a table1.a%type;
v_str varchar2(2000);begin
select a into v_a from table1;for v_aa in 1..v_a loop
if(length(str)=0)then
str:=v_aa;
else
str:=str ||','|| v_aa;
end if;end loop;
insert into table2 values(str);end;... |
|
