xsd格式编号，5位小数(xsd format number , 5 decimal places)

xsd格式编号，5位小数(xsd format number , 5 decimal places)

我有xsd代码，它将LINE_AMOUNT值打印为14,952.59，现在我想将其显示为14,952.59000（5位小数）。

如何实现这一目标？

谢谢

I have xsd code which is printing LINE_AMOUNT value as 14,952.59 , now i want to display this as 14,952.59000(5 decimal places).

How to achieve this?

Thank you

最满意答案

SQL小提琴

查询1要么（如果你想使用当前的NLS值为小数和千字符）：

SELECT TO_CHAR( 14952.59, 'FM9G999G999G999G990D00000' ) FROM DUAL

结果 ：

| TO_CHAR(14952.59,'FM9G999G999G999G990D00000') | |-----------------------------------------------| | 14,952.59000 |

查询2或：

SELECT TO_CHAR( 14952.59, 'FM9,999,999,999,990.00000' ) FROM DUAL

结果 ：

| TO_CHAR(14952.59,'FM9,999,999,999,990.00000') | |-----------------------------------------------| | 14,952.59000 |

---

更新 ： SQL小提琴

查询3 ：

SELECT TO_CHAR( TO_NUMBER( '13,214,952.59', 'FM9G999G999G999G990D99999' ), 'FM9G999G999G999G990D00000' ) AS formatted_value FROM DUAL

结果 ：

| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |

查询4 ：

SELECT TO_CHAR( TO_NUMBER( '13,214,952.59', 'FM9,999,999,999,990.99999' ), 'FM9,999,999,999,990.00000' ) AS formatted_value FROM DUAL

结果 ：

| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |

SQL Fiddle

Query 1 Either (if you want to use the current NLS values for decimal and thousands characters):

SELECT TO_CHAR( 14952.59, 'FM9G999G999G999G990D00000' ) FROM DUAL

Results:

| TO_CHAR(14952.59,'FM9G999G999G999G990D00000') | |-----------------------------------------------| | 14,952.59000 |

Query 2 or:

SELECT TO_CHAR( 14952.59, 'FM9,999,999,999,990.00000' ) FROM DUAL

Results:

| TO_CHAR(14952.59,'FM9,999,999,999,990.00000') | |-----------------------------------------------| | 14,952.59000 |

---

Update: SQL Fiddle

Query 3:

SELECT TO_CHAR( TO_NUMBER( '13,214,952.59', 'FM9G999G999G999G990D99999' ), 'FM9G999G999G999G990D00000' ) AS formatted_value FROM DUAL

Results:

| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |

Query 4:

SELECT TO_CHAR( TO_NUMBER( '13,214,952.59', 'FM9,999,999,999,990.99999' ), 'FM9,999,999,999,990.00000' ) AS formatted_value FROM DUAL

Results:

| FORMATTED_VALUE | |------------------| | 13,214,952.59000 |