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 ?
Something like this?
select to_char(5000, '9999l'), to_char(5000, 'l9999')
from dual
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