Oracle下各个NLS相关参数取得方法
磨砺技术珠矶,践行数据之道,追求卓越价值
回到上一级页面: PostgreSQL杂记页 回到顶级页面:PostgreSQL索引页
[作者 高健@博客园 luckyjackgao@gmail.com]
1)---------------------------------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET:
SQL> select * from nls_database_parameters where parameter='NLS_NCHAR_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
UTF8
SQL>
2)---------------------------------------------------------------------------------------------------------
NLS_LANGUAGE:
SQL> show parameter NLS_LANGUAGE;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string JAPANESE
SQL>
3)---------------------------------------------------------------------------------------------------------
NLS_TERRITORY:
SQL> show parameter NLS_TERRITORY;
show parameter NLS_TERRITORY;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_territory string JAPAN
SQL>
4)---------------------------------------------------------------------------------------------------------
NLS_CURRENCY:
SQL> show parameter NLS_CURRENCY;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_currency string ¥
SQL>
5)---------------------------------------------------------------------------------------------------------
NLS_ISO_CURRENCY:
SQL> show parameter NLS_ISO_CURRENCY;
show parameter NLS_ISO_CURRENCY;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_iso_currency string JAPAN
SQL>
6)---------------------------------------------------------------------------------------------------------
NLS_NUMERIC_CHARACTERS:
SQL> show parameter NLS_NUMERIC_CHARACTERS;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_numeric_characters string .,
SQL>
7)---------------------------------------------------------------------------------------------------------
NLS_CHARACTERSET:
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
JA16SJIS
SQL>
8)---------------------------------------------------------------------------------------------------------
NLS_CALENDAR:
SQL> show parameter NLS_CALENDAR;
show parameter NLS_CALENDAR;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string GREGORIAN
SQL>
9)----------------------------------------------------------------------------------------------------------
NLS_DATE_FORMAT:
SQL> show parameter NLS_DATE_FORMAT;
show parameter NLS_DATE_FORMAT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string RR-MM-DD
SQL>
10)----------------------------------------------------------------------------------------------------------
NLS_DATE_LANGUAGE:
SQL> show parameter NLS_DATE_LANGUAGE;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_language string JAPANESE
SQL>
11)----------------------------------------------------------------------------------------------------------
NLS_SORT:
SQL> show parameter NLS_SORT;
show parameter NLS_SORT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string BINARY
SQL>
12)----------------------------------------------------------------------------------------------------------
NLS_TIME_FORMAT:
SQL> show parameter NLS_TIME_FORMAT;
show parameter NLS_TIME_FORMAT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_time_format string HH24:MI:SSXFF
SQL>
13)----------------------------------------------------------------------------------------------------------
NLS_TIMESTAMP_FORMAT:
SQL> show parameter NLS_TIMESTAMP_FORMAT;
AMP_FORMAT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_timestamp_format string RR-MM-DD HH24:MI:SSXFF
SQL>
14)----------------------------------------------------------------------------------------------------------
NLS_TIME_TZ_FORMAT:
SQL> show parameter NLS_TIME_TZ_FORMAT;
show parameter NLS_TIME_TZ_FORMAT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_time_tz_format string HH24:MI:SSXFF TZR
SQL>
15)----------------------------------------------------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT:
SQL> select * from nls_database_parameters where parameter='NLS_TIMESTAMP_TZ_FORMAT';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
SQL>
16)----------------------------------------------------------------------------------------------------------
NLS_DUAL_CURRENCY:
SQL> show parameter NLS_DUAL_CURRENCY;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_dual_currency string ¥
SQL>
17)----------------------------------------------------------------------------------------------------------
NLS_COMP:
SQL> show parameter NLS_COMP;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_comp string BINARY
SQL>
18)----------------------------------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS:
SQL> show parameter NLS_LENGTH_SEMANTICS;
show parameter NLS_LENGTH_SEMANTICS;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics string BYTE
SQL>
19)----------------------------------------------------------------------------------------------------------
NLS_NCHAR_CONV_EXCP:
SQL> show parameter NLS_NCHAR_CONV_EXCP;
show parameter NLS_NCHAR_CONV_EXCP;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_nchar_conv_excp string FALSE
SQL>
20)-------------------
NLS_RDBMS_VERSION:
SQL> select property_value from database_properties where property_name='NLS_RDBMS_VERSION';
select property_value from database_properties where property_name='NLS_RDBMS_VERSION';
PROPERTY_VALUE
--------------------------------------------------------------------------------
11.2.0.3.0
SQL>
[作者 高健@博客园 luckyjackgao@gmail.com]
回到上一级页面: PostgreSQL杂记页 回到顶级页面:PostgreSQL索引页
磨砺技术珠矶,践行数据之道,追求卓越价值
相关文章
- Oracle数据库误操作回滚到指定的时间点方法
- SQL Developer 连接 oracle数据库 报错 Io 异常 The Network Adapter could not establish the connection的三种解决方法
- 非常规方法,轻松应对Oracle数据库危急异常
- [转]PL/SQLDeveloper导入导出Oracle数据库方法
- Oracle数据库的状态查询
- oracle 索引失效原因及解决方法
- oracle中动态SQL使用详细介绍
- 《Oracle性能优化与诊断案例精选》——1.2 京师磨练,转眼已历十二载
- 《Oracle性能优化与诊断案例精选》——2.2 日久生情见真心
- ORACLE删除当前用户下所有的表的方法
- 【Oracle】INSERT INTO SELECT语句和SELECT INTO FROM语句的区别
- oracle函数 extract(c1 from d1)
- oracle-ORA-00942错误
- 转 Oracle中merge into的使用
- excel 录入oracle 方法
- sql: Oracle 11g create table, function,trigger, sequence
- Oracle 11g随Redhat 5系统自动启动与关闭的设置方法
- Oracle的操作系统身份认证(转)
- [Oracle工程师手记] Data Guard 环境中,查找最近发生的与 Data Guard 相关的错误的方法
- [Oracle 工程师手记] Windows 环境下,获取与 oracle 相关 registry 的小技巧
- [Oracle 工程师手记]探究 Oracle PDB Application Container (五)
- [Oracle]Master表字段扩张时的对应方法
- [Oracle]查看数据是否被移入 DataBuffer 的方法
- 重启oracle方法一二三
- Oracle wm_concat函数排序的解决方法