create table kol.MTL_MATERIAL_TRANS_TMP_140325 as select * from MTL_MATERIAL_TRANSACTIONS_TEMP ;
update
MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
Set
mmtt.PROCESS_FLAG = ‘Y‘,
mmtt.LOCK_FLAG = ‘N‘,
mmtt.TRANSACTION_MODE = 3,
mmtt.transaction_status = 2,
mmtt.ERROR_CODE = NULL
Where NVL(mmtt.TRANSACTION_STATUS,0)
<> 2;
Oracle - Unprocessed Material,布布扣,bubuko.com
原文：http://www.cnblogs.com/quanweiru/p/3623268.html