将货币符号£，$添加到某些字段ORACLE [英] Add Currency Sign £, $ to certain fields ORACLE

问题描述

我想在任何人都知道的持有job_salary的字段中显示美元或英镑符号吗?怎么

I want to display the dollar or pound sign in my fields that hold job_salary any one knows? how to

推荐答案

在格式掩码中使用$对美元符号进行硬编码(毕竟，Oracle是一家美国公司).其他货币取决于NLS_TERRITORY的设置.使用C查看ISO货币缩写(UKP)，并使用L表示符号(£).

Using $ in the format mask hardcodes a dollar sign (after all, Oracle is an American corporation). Other currencies are determined by the setting for NLS_TERRITORY. Use C to see the ISO currency abbreviation (UKP) and L for the symbol (£).

SQL> select to_char(sal, 'C999,999.00') as ISO
  2         , to_char(sal, 'L999,999.00') as symbol from emp
  3  /

ISO                SYMBOL
------------------ ---------------------
       GBP3,500.00             £3,500.00
       GBP3,750.00             £3,750.00 

...

这篇关于将货币符号£，$添加到某些字段ORACLE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！