4 Replies Latest reply: Apr 26, 2013 3:39 PM by Gary Graham-Oracle RSS

    How to change NLS parameters in SQL Developer?

    961271
      I think that Oracle National Language Support is quite confusing. How can I easily change NLS parameters for SQL Developer (for all connections) to match exactly those that my database is using?
        • 1. Re: How to change NLS parameters in SQL Developer?
          Marwim
          Extras - Preferences - Database - NLS

          IMHO the default setting is derived from the default setting of your OS-language.

          Regards
          Marcus
          • 2. Re: How to change NLS parameters in SQL Developer?
            961271
            Thanks, I tried to change decimal separator from comma to dot, but that did not change the way the results are displayed in number fields? How to change these values permanately?
            • 3. Re: How to change NLS parameters in SQL Developer?
              Marwim
              Hello,
              SELECT 5/8 x FROM dual;
              F9 -> 0.625
              Change decimal separator in preferences
              F9 -> 0,625

              It is different when I execute a query/script with F5, then I always get 0.625
              SELECT * FROM nls_session_parameters
              WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
              
              PARAMETER                      VALUE
              ------------------------------ ----------------------------------------
              NLS_NUMERIC_CHARACTERS         .,
              
              
              SELECT 5/8 x FROM dual;
              
                       X
              ----------
                   0.625
               
              Change settings
              SELECT * FROM nls_session_parameters
              WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
              
              PARAMETER                      VALUE
              ------------------------------ ----------------------------------------
              NLS_NUMERIC_CHARACTERS         ,.
              
              
              SELECT 5/8 x FROM dual;
              
                       X
              ----------
                   0.625
              Even changing the settings with ALTER SESSION makes no difference
              ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';
              
              SELECT * FROM nls_session_parameters
              WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
              
              PARAMETER                      VALUE
              ------------------------------ ----------------------------------------
              NLS_NUMERIC_CHARACTERS         ,.
              
              
              SELECT 5/8 x FROM dual;
              
                       X
              ----------
                   0.625
              
              ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,';
              
              SELECT * FROM nls_session_parameters
              WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
              
              PARAMETER                      VALUE
              ------------------------------ ----------------------------------------
              NLS_NUMERIC_CHARACTERS         .,
              
              
              SELECT 5/8 x FROM dual;
              
                       X
              ----------
                   0.625
              It seems the script output does not care about my settings :-(

              Regards
              Marcus
              • 4. Re: How to change NLS parameters in SQL Developer?
                Gary Graham-Oracle
                Hi Marcus,

                As an FYI, I logged
                Bug 16038206 - FORUM: NLS DECIMAL / GROUP SEPARATORS, SET NLS_NUMERIC_CHAR IGNORED

                for this issue based on a prior forum report:
                Strange behavior NLS settings when Run Script (F5) - compared to SQL Plus

                -Gary-