title: SQL to_char Currency Formatting
body: <p>I am facing a <code>to_char()</code> currency formatting problem here.</p>
  <p>The below code is working for me:</p>
  <pre><code>SELECT TO_CHAR(10000,'L99G999D99MI',
                 'NLS_NUMERIC_CHARACTERS = ''.,''
                 NLS_CURRENCY = $') &quot;Amount&quot;
    FROM DUAL; 
  </code></pre>
  <p>which will provide me with the output: <code>$10,000.00</code>.<br />
  Now, I want to convert the currency into a France currency, which the desire output is <code>10 000,00</code> or a Switzerland currency with output <code>10'000.00</code>. So, I modified the code as shown below for both of the case above:</p>
  <pre><code>SELECT TO_CHAR(10000,'L99G999D99MI',
                 'NLS_NUMERIC_CHARACTERS = ''&quot;&quot;, &quot;&quot;''
                 NLS_CURRENCY = ''$'' ') &quot;Amount&quot;
    FROM DUAL;
  
  
  SELECT TO_CHAR(10000,'L99G999D99MI',
                 'NLS_NUMERIC_CHARACTERS = ''&quot;. &quot;''
                 NLS_CURRENCY = ''$'' ') &quot;Amount&quot;
    FROM DUAL;
  </code></pre>
  <p>But this code does not work and showing an error of <code>ORA-12702</code>. Is there any problem with the code?</p>