Teamcenter 更改计量单位

update infodba.pitem p
set p.ruom_tagu =
(select uom.puid
from infodba.punitofmeasure uom
where uom.psymbol = 'Decimal'),
p.ruom_tagc='497'
where p.pitem_id in ('8891562609');

select * from infodba.punitofmeasure uom