oracle 一張表插入另外一張表 預存程序

標籤：

 

 

----建立預存程序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;

 

oracle 一張表插入另外一張表 預存程序