0 Replies Latest reply on Apr 16, 2015 3:28 PM by Marwim

    NLS Settings in Preferences - Decimal Separator - useless?




      a minor thing I found recently: settings for the Group/Decimal separator seems to have no influence on the displayed data.

      Whatever setting I have for the decimal separator, the only setting that influences the displayed data is the Territory.

      E.g. I execute SELECT 6/5 FROM dual;


      Version3. /
      Execute withF5F9F5F9
      Territory AMERICA1.
      Territory GERMANY1.21,21,21,2


      I only get a comma as separator when I set Territory = GERMANY and even this setting is ignored in the previous version 3.2.2


      I would expect that the settings for Group and Decimal Separators overrule the Territory setting.





      Edit: Language is set to GERMAN, Decimal separator is set to ","