title: How to format amount values for French locale
body: <p>We are using a stored procedure in Oracle 12c to calculate and return some amounts. As we have clients in various countries, we received a requirement to display the amounts as per French Locale format based a a particular environment variable.</p>
  <p>Here is the exact issue:</p>
  <p>The regular amount format would be like 5,000.00</p>
  <p>For this, we use <code>select (TRIM(TO_CHAR('5000','999,999,999,999,999.99') ))  from dual;</code></p>
  <p>--&gt;5,000.00</p>
  <p>But for French locale, it should be returned like <strong>5 000,00</strong></p>
  <p>Please suggest if Oracle provides any functions to support amounts based on Locales than using Replace over the above statement when the locale is French:</p>
  <pre><code>select replace(replace((TRIM(TO_CHAR('5000','999,999,999,999,999.99') )),',',' '),'.',',')  from dual;
  </code></pre>
  <p>--&gt; 5 000,00</p>