Oracle數(shù)據(jù)庫中保留小數(shù)點(diǎn)后兩位的問題解讀
Oracle數(shù)據(jù)庫中保留小數(shù)點(diǎn)后兩位的問題
1.數(shù)字保留兩位小數(shù)
(小數(shù)點(diǎn)左側(cè)數(shù)字可能比較大,比如10000000.12)
to_char() 函數(shù)轉(zhuǎn)換
答案
select trim(to_char(85.7323232, '9999999990.00')) as 兩位小數(shù) from dual;
寫法對(duì)比
select result, to_char(result, '9999.99') as "位數(shù)不足", to_char(result, '9999999999.99') as "位數(shù)充足", to_char(result, '0000.00') as "0的位數(shù)不足", to_char(result, '0000000000.00') as "0的位數(shù)充足", to_char(result, '9999999990.00') as "9的位數(shù)充足", trim(to_char(result, '9999999990.00')) as "9的位數(shù)充足且去掉左側(cè)" from ( select 0 result from dual union select 1 result from dual union select 123 result from dual union select 123.4 result from dual union select 12345.67 result from dual union select 12345678.2 result from dual )
2.百分比保留兩位小數(shù)
(小數(shù)點(diǎn)左側(cè)數(shù)字?jǐn)?shù)字小于等于100,比如86.63%)
答案
select trim(to_char(0.7323232 * 100, '99990.99'))||'%' as 百分比 from dual;
select trim(to_char(0.7323232 * 100, '99990.99'))||'%' as 百分比 from dual;
寫法對(duì)比
select result, to_char(result * 100, '99.99') || '%' as "9位數(shù)不足", to_char(result * 100, '00.99') || '%' as "0位數(shù)不足", to_char(result * 100, '99990.99') || '%' as "百分比", trim(to_char(result * 100, '99990.99')) || '%' as "去左側(cè)空格的百分比", to_char(result * 100, 'fm99990.99') || '%' as "使用fm前綴的格式百分比", to_char(result * 100, 'fm99990.00') || '%' as "使用fm前綴的格式百分比2" from ( select 0 result from dual union select 1 result from dual union select 0.12345 result from dual union select 0.2 result from dual union select 0.23 result from dual union select 0.234 result from dual union select 0.2345 result from dual union select 0.23454 result from dual union select 0.23456 result from dual )
總結(jié)
以上為個(gè)人經(jīng)驗(yàn),希望能給大家一個(gè)參考,也希望大家多多支持腳本之家。
相關(guān)文章
oracle自動(dòng)清理archivelog文件的具體方法
這篇文章介紹了oracle自動(dòng)清理archivelog文件的具體方法,有需要的朋友可以參考一下2013-09-09Oracle數(shù)據(jù)庫中的控制文件管理以及常用參數(shù)設(shè)置
這篇文章主要介紹了Oracle數(shù)據(jù)庫中的控制文件管理以及常用參數(shù)設(shè)置方法,包括控制文件不一致問題的解決方法以及隱藏參數(shù)等技巧,需要的朋友可以參考下2015-12-12oracle與gbase8s遷移數(shù)據(jù)類型對(duì)照以及舉例說明
gbase8s是一個(gè)高性能的分布式關(guān)系型數(shù)據(jù)庫,下面這篇文章主要給大家介紹了關(guān)于oracle與gbase8s遷移數(shù)據(jù)類型對(duì)照以及舉例說明的相關(guān)資料,文中通過圖文介紹的非常詳細(xì),需要的朋友可以參考下2023-12-12Oracle數(shù)據(jù)庫常用命令整理(實(shí)用方法)
這篇文章主要介紹了Oracle數(shù)據(jù)庫常用命令整理(實(shí)用方法),本文給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2020-06-06Oracle數(shù)據(jù)庫中字符串截取最全方法總結(jié)
Oracle提供了多種截取字符串的操作方法,可以根據(jù)具體需求選擇合適的方法進(jìn)行操作,下面這篇文章主要給大家總結(jié)介紹了關(guān)于Oracle數(shù)據(jù)庫中字符串截取的最全方法,需要的朋友可以參考下2024-03-03