create procedure pro
as
str varchar2(50);
cursor t_sor is
select field1 from table1;
begin
for v_sor in t_sor loop
str:=str||v.sor.field1;
end loop;
insert into table2 (field2) values(to_number(str));
end;
/
as
str varchar2(50);
cursor t_sor is
select field1 from table1;
begin
for v_sor in t_sor loop
str:=str||v.sor.field1;
end loop;
insert into table2 (field2) values(to_number(str));
end;
/
cursor curGetData is select * from table1 where item_name = ....;
rowValue curGetData%rowtype;
begin
for rowValue in curGetData loop
insert into table2(item) values(rowValue.item);
end loop;
commit;
end;