Add Currency Sign £, $ to certain fields ORACLE

Question

Hi Geniuses

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

Answer 1

i GOT IT IS

COLUMN EMP_SALARY FORMAT $9,999.99

Answer 2

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 

...