update T_IM_PurInWarehsEntry set FUNITSTANDARDCOST=FPRICE,FUNITACTUALCOST=FPRICE,FUNITPURCHASECOST=FPRICE,FPURCHASECOST=FAMOUNT,FSTANDARDCOST=FAMOUNT,FACTUALCOST=FAMOUNT where FSTORAGEORGUNITID='10YAAAAAGSPM567U' and FMATERIALID='10YAAAAJel1ECefw' and FBIZDATE between to_date('2019-04-01','yyyy-MM-dd') AND to_date('2019-08-05','yyyy-MM-dd')标签：dd,FPRICE,FAMOUNT,更新,实际成本,yyyy,2019,sql,date From： https://blog.51cto.com/u_11343833/6091638