1 Reply Latest reply: Jan 23, 2013 3:37 PM by fac586 RSS

    Currency symbol

    user555036-Oracle
      I am using Apex 4.2

      I attach to the database sys as sysdba and run from SQL developer ;

      select * from v$nls_parameters;

      I get

      NLS_CURRENCY = '£'

      I put a number in Apex, and I understand Apex handling of numbers as text, so I use:

      to_char(:P3_NUMBER_VARIABLE, 'L9,999.00')

      I still get $120.00

      Any idea why?
        • 1. Re: Currency symbol
          fac586
          >

          Please update your forum profile with a real handle instead of "user555036".
          I am using Apex 4.2

          I attach to the database sys as sysdba and run from SQL developer ;

          select * from v$nls_parameters;

          I get

          NLS_CURRENCY = '£'

          I put a number in Apex, and I understand Apex handling of numbers as text, so I use:

          to_char(:P3_NUMBER_VARIABLE, 'L9,999.00')

          I still get $120.00

          Any idea why?
          The NLS settings for an APEX application are determined by the app's Globalization attributes.

          <li>About Language Identification
          <li>Specifying the Primary Language for an Application

          What are the Application Primary Language and Application Language Derived From settings?