INSERT INTO xxx
SELECT xx FROM xxx
RETURNING object_type(xxx) BULK COLLECT INTO xxxcollection;
forall j IN xxxcollection.FIRST..xxxcollection.LAST
insert into newtable;
INSERT INTO xxx
SELECT xx FROM xxx
RETURNING object_type(xxx) BULK COLLECT INTO xxxcollection;
forall j IN xxxcollection.FIRST..xxxcollection.LAST
insert into newtable;
转载于:https://my.oschina.net/u/2893/blog/388265