--查询库位表中没有的库位

select * from L_IMPORTDATA_TEMP  where location_code not in (select t.location_code from l_location t) ;

--第一步：插入库位表中没有的刻录

--insert into l_location select * from L_IMPORTDATA_TEMP  where location_code not in (select t.location_code from l_location t) ;

--commit;

--第二步：更新记录数据

--没用select * from l_location l where l.location_code in (select location_code from L_IMPORTDATA_TEMP);

--闪回Insert Into L_LOCATION (Select * From L_LOCATION As Of Timestamp to_Timestamp('2012-3-24  13:24:30','yyyy-mm-dd hh24:mi:ss') )

savepoint derek;

UPDATE  l_location L

SET  ( materialscode,capacity,inventory,shelfnum,orders,status,fathercode,isvirtualreal)=

(SELECT materialscode,capacity,inventory,shelfnum,orders,status,fathercode,isvirtualreal FROM L_IMPORTDATA_TEMP T WHERE l.location_code = t.location_code and  l.storagecode=209)

where location_code in (select location_code from L_IMPORTDATA_TEMP) and l.storagecode=209;

commit;