java中從oracle中取數(shù)據(jù)，轉(zhuǎn)化為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


久久不醉