create or replace procedure insert_table as
cursor cs is select * from Table1
begin
for c in cs loop
BEGIN
insert into tableA(Aid,AName,Acontent,Asize,Alenght) values
(table1.id,table1.name,table1.acontent,table1.size,c.table1.size);
END;
end loop;
end insert_table ;
cursor cs is select * from Table1
begin
for c in cs loop
BEGIN
insert into tableA(Aid,AName,Acontent,Asize,Alenght) values
(table1.id,table1.name,table1.acontent,table1.size,c.table1.size);
END;
end loop;
end insert_table ;