显示最大四位，四舍五入，超过5位则####代替。http://www.cndba.cn/hbhe0316/article/107969http://www.cndba.cn/hbhe0316/article/107969http://www.cndba.cn/hbhe0316/article/107969http://www.cndba.cn/hbhe0316/article/107969

SQL> CREATE TABLE PRODUCT (PRICE NUMBER(8,2));

Table created.

SQL> insert into PRODUCT VALUES (1023.99);

1 row created.

SQL> insert into PRODUCT VALUES (10235.99);

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT TO_CHAR(PRICE,'$9,999') FROM PRODUCT;

TO_CHAR(PRICE,'$9,999
---------------------
 $1,024
#######

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle