1. 从游标中读取,采取for循环存入记录类型,将记录类型写入表
declare
cursor cur_date is
select * from table ;
l_iface_rec table%ROWTYPE;
begin
for src in cur_date loop
l_iface_rec.line_name:=src.line_name;
...
INSERT INTO table VALUES l_iface_rec;
end loop;
end;
2. 从表中读取数据存入另一张表
INSERT INTO table
(iface_id, org_id)
SELECT iface_id, org_id
FROM table1 p
where p.iface_id = 1393355