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


久久不醉