Change NLS_NUMERIC_CHARACTERS from ., to ,.
417843May 14 2009 — edited May 14 2009Hello,
I want to change NLS_NUMERIC_CHARACTERS value from *.,* to *,.*. I have followed below steps.
1. select * from nls_database_parameters where PARAMETER='NLS_NUMERIC_CHARACTERS';
PARAMETER VALUE
--------------------------------- --------------------
NLS_NUMERIC_CHARACTERS .,
1. alter system set nls_numeric_characters =',.' scope=spfile
2. Restart Database
3. select * from nls_database_parameters where PARAMETER='NLS_NUMERIC_CHARACTERS';
PARAMETER VALUE
--------------------------------- --------------------
NLS_NUMERIC_CHARACTERS .,
Can someone please help to understand why NLS_NUMERIC_CHARACTERS is not changed to updated value. In SPFile I can see *.nls_numeric_characters=',.'
Thanks,
Kishor
Edited by: Kishor Bhede on May 14, 2009 4:01 PM