1.查看数据库有效的nls相关参数
SQL> select * from
SQL> select * from
2 (
3 select row_number()over(partition by parameter order by parameter) rn,parameter,value,isdeprecated
4 from
5 v$nls_valid_values
6 )
7 where rn=1;
RN PARAMETER VALUE ISDEP
---------- -------------------- ---------------------- -----
1 CHARACTERSET US7ASCII FALSE
1 LANGUAGE AMERICAN FALSE
1 SORT BINARY FALSE
1 TERRITORY AMERICA FALSE
2. 查看当前会话的nls相关设置
2. 查看当前会话的nls相关设置
SQL> select * from v$nls_parameters;
PARAMETER VALUE
------------------------- ------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ¥
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
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
已选择19行。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10972173/viewspace-723495/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10972173/viewspace-723495/