marnell21
10/13/2015 - 2:31 PM

Oracle TO_CHAR function

From http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions181.htm

to_char.sql
content_copyfile_download
SELECT TO_CHAR(-10000,'L99G999D99MI') "Amount"
     FROM DUAL;

Amount
--------------
  $10,000.00-

SELECT TO_CHAR(-10000,'L99G999D99MI',
   'NLS_NUMERIC_CHARACTERS = '',.''
   NLS_CURRENCY = ''AusDollars'' ') "Amount"
     FROM DUAL;

Amount
-------------------
AusDollars10.000,00-