Hello ! Could you please answer the following question - how to get 'USD' or other value for numbers based on nls_iso_currency parameter's value ? I guess it is possible to use regexp or something like that functions like:
1 select regexp_replace (one_usd,'[0-9]+') from
2 (
3 select to_char (1000,'9999c') as one_usd from dual
4* )
But is there more simple way like select nls_iso_currency_value from dual ;
And how to place space between the number and 'USD', for example ?
Thank you very much in advance
Dmitry