Oracle to_char 转换数值

最新推荐文章于 2022-07-18 16:28:02 发布

weixin_33989058

最新推荐文章于 2022-07-18 16:28:02 发布

阅读量164

点赞数

文章标签：数据库

SQL> Select CONCAT(TO_CHAR('0.001'*100,'990.99'),'%') FROM DUAL;

CONCAT(TO_CHAR('
----------------
0.10%

SQL> select to_char(1234567.89,'9,999,999.99') id from dual;

ID
--------------------------
1,234,567.89

SQL> select to_char(1234567.89,'999,999,999.99') id from dual;

ID
------------------------------
1,234,567.89

SQL> select to_char(1234567.89,'009,999,999.9900') id from dual;

ID
----------------------------------
001,234,567.8900

SQL> select to_char(1234567.89,'9.99EEEE') id from dual;

ID
--------------------
1.23E+06

SQL> select to_char(1234567.89,'999999.99EEEE') id from dual;

ID
--------------------
1.23E+06



SQL> select to_char(-1234567.89,'999,999,999.99PR') id from dual;

ID
--------------------------------
<1,234,567.89>