Search code examples
oracle-databasecurrencyoraclereports

Oracle report, add currency symbol after values


If I add currency symbol to values it's look like: $5000, I want that currency symbol will be after value: 5000$, possible to format ?


Solution

  • Something like this?

    select to_char(5000, '9999l'), to_char(5000, 'l9999')
    from dual
    

    Here is a sqlfiddle demo


    If you don't want to specify the length you can do (I don't like this solution...):

    select substr(trim(to_char('1', 'l9')), 1, 1) || 5000
    from dual
    

    Here is another sqlfiddle demo