java中从oracle中取数据,转化为String和Double显示:
String------->.11
Double------->1.23456446412E10
decode(substr(to_char(CHARGE_AMOUNT/100),1,1),'.','0'||to_char(CHARGE_AMOUNT/100),to_char(CHARGE_AMOUNT/100)) chargeAmountYuan
java中从oracle中取数据,转化为String和Double显示:
String------->.11
Double------->1.23456446412E10