UOM Convertion Rate API

来源：互联网发布：查看淘宝账号注册时间编辑：程序博客网时间：2024/06/05 07:39

计量单位转换API

set serveroutput on;Declarev_Rate Number(30,23);v_itemid  number default  2036;Beginv_rate := INV_CONVERT.INV_UM_CONVERT (                                   ITEM_ID         => v_itemid,                                   PRECISION       => 10,                                   FROM_QUANTITY   => 1,                                   FROM_UNIT       => '米',                                   TO_UNIT         => '吨',                                   FROM_NAME       => NULL,                                   TO_NAME         => NULL                                );dbms_output.put_line('Rate :' ||v_rate);end;

计算结果表示： 1 米(From_Unit) = Rate * 吨(To_Unit)

Precision为转换率的小数位精度。