By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select value from nls_session_parameters where parameter = 'NLS_CURRENCY';
| VALUE |
|---|
| £ |
select to_char(123.45, 'FM999G999G999G999G990D00L') from dual;
| TO_CHAR(123.45,'FM999G999G999G999G990D00L') |
|---|
| 123.45£ |
select to_char(123.45, 'FM999G999G999G999G990D00" "L') from dual;
ORA-01481: invalid number format model
select to_char(123.45, 'FM999G999G999G999G990D00L', 'nls_currency='' $''') from dual;
| TO_CHAR(123.45,'FM999G999G999G999G990D00L','NLS_CURRENCY=''$''') |
|---|
| 123.45 $ |
select 'nls_currency='' ' || value || '''' from nls_session_parameters where parameter = 'NLS_CURRENCY';
| 'NLS_CURRENCY='''||VALUE||'''' |
|---|
| nls_currency=' £' |
select to_char(123.45, 'FM999G999G999G999G990D00L', (select 'nls_currency='' ' || value || '''' from nls_session_parameters where parameter = 'NLS_CURRENCY')) from dual;
| TO_CHAR(123.45,'FM999G999G999G999G990D00L',(SELECT'NLS_CURRENCY='''||VALUE||''''FROMNLS_SESSION_PARAMETERSWHEREPARAMETER='NLS_CURRENCY')) |
|---|
| 123.45 £ |
alter session set nls_currency = ' €'
select to_char(123.45, 'FM999G999G999G999G990D00L') from dual;
| TO_CHAR(123.45,'FM999G999G999G999G990D00L') |
|---|
| 123.45 € |