这样写可以吗?
update prs_uprice_f set prs_uprice_f.uprice=v_money_tonet.netprice where (prs_uprice_f.partcode||’-’||supcode) =v_money_tonet.code
update prs_uprice_f set prs_uprice_f.uprice=v_money_tonet.netprice where (prs_uprice_f.partcode||’-’||supcode) =v_money_tonet.code
(select v_money_tonet.netprice from v_money_tonet
where v_money_tonet.code = prs_uprice_f.partcode||’-’||prs_uprice_f.supcode)
有更好一点的语句吗?