Changing values in v$nls_parameters.
440025Jul 17 2006 — edited Jul 17 2006below is the result of query. Select * from v$nls_parameters.
i want to change the value of parameter NLS_LANGUAGE FROM AMERICAN TO RUSSIAN. NLS_TERRITORY FROM AMERICA TO RUSSIA AND NLS_CHARACTERSET FROM WE8MSWIN1252 TO UTF8.
How can i do this.
Also is the territory russia and language russian is correct.
if i set the NLS_LANG FROM AMERICAN_AMERICA.WE8MSWIN1252 (which is present in the rgistery) to RUSSIAN_RUSSIA.UTF8, Will this work. and wat will be the values in the view V$NLS_PARAMETER.
plz help this is very urgent.
PARAMETER VALUE
-------------------------- ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
-------------------------- ------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
Message was edited by:
437022
Message was edited by:
437022