Oracle数据库字段值只保留小数点后几位
select
decode(ts.property_14, 0, '0.0000',(to_char(round(ts.property_14 , 4), 'fm99999999999999.0000'))) property_14
from test_table ts
Oracle数据库字段值只保留小数点后几位
select
decode(ts.property_14, 0, '0.0000',(to_char(round(ts.property_14 , 4), 'fm99999999999999.0000'))) property_14
from test_table ts