从一张表插入另一张表的存储过程;
----创建存储过程
create or replace procedure inserttest as
cursor cs is
select id, name, cla, addr, phone, tel, x, y, shape, objectid
from hotel_bak t2;
begin
for c in cs loop
BEGIN
insert into hotel
(id, name, cla, addr, phone, tel, x, y, shape, objectid)
values
((select max(id) + 1 from hotel),
c.name,
c.cla,
c.addr,
c.phone,
c.tel,
c.x,
c.y,
c.shape,
(select max(objectid) + 1 from hotel));
END;
end loop;
end inserttest;
---执行存储过程
call inserttest();
commit;