NLS(National Language Support)

NLS(National Language Support)

Posted on 2009-06-28 20:34 hallo 阅读( 1007) 评论( 0) 编辑 收藏

    NLS - 区域语言支持，用来定义用户所在区域的日期格式，计数方法，货币单位以及语言设置等选项。就比如中国内地的区域设置，见下图。

 

    NLS 技术的使用，可以把货币符号从 $ 转换为 ￥ ，语言从 英文 转成 中文。这样用户就可以使用母语来与 Oracle 进行交互，并且遵循用户的数据显示惯例。

    下面的 SQL 实例演示了 NLS 参数的功用。

● 客户端参数(Client Parameters)

    可以通过 ALTER SESSION 命令更改此参数   

SQL >   SELECT   *   FROM  nls_session_parameters;
 
PARAMETER                                      VALUE
– ——————————————– ———————————–
NLS_LANGUAGE                                   SIMPLIFIED CHINESE
NLS_TERRITORY                                  CHINA
NLS_CURRENCY                                   RMB
NLS_ISO_CURRENCY                               CHINA
NLS_NUMERIC_CHARACTERS                         .,
NLS_CALENDAR                                   GREGORIAN
NLS_DATE_FORMAT                                dd - mon - yy
NLS_DATE_LANGUAGE                              AMERICAN
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                              RMB
NLS_COMP                                        BINARY
NLS_LENGTH_SEMANTICS                           BYTE
NLS_NCHAR_CONV_EXCP                            FALSE
 
17  rows selected
 

● 实例参数(Instance Parameters)

    可以通过 ALTER SYSTEM 命令更改此参数 

SQL >   SELECT   *   FROM  nls_instance_parameters;
 
PARAMETER                                      VALUE
– ——————————————– —————
NLS_LANGUAGE                                   AMERICAN
NLS_TERRITORY                                  AMERICA
NLS_SORT                                       
NLS_DATE_LANGUAGE                              
NLS_DATE_FORMAT                                
NLS_CURRENCY                                   
NLS_NUMERIC_CHARACTERS                         
NLS_ISO_CURRENCY                               
NLS_CALENDAR                                   
NLS_TIME_FORMAT                                
NLS_TIMESTAMP_FORMAT                           
NLS_TIME_TZ_FORMAT                             
NLS_TIMESTAMP_TZ_FORMAT                        
NLS_DUAL_CURRENCY                              
NLS_COMP                                       
NLS_LENGTH_SEMANTICS                           BYTE
NLS_NCHAR_CONV_EXCP                            FALSE
 
17  rows selected

 ● 数据库参数(Database Parameters)

     在数据库的创建过程中进行设置。

SQL >   SELECT   *   FROM  NLS_DATABASE_PARAMETERS;
 
PARAMETER                      VALUE
– —————————- ————————————-
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   <br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_ISO_CURRENCY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AMERICA<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_NUMERIC_CHARACTERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.,<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_CHARACTERSET&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZHS16GBK<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_CALENDAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GREGORIAN<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_DATE_FORMAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DD</span><span style="color: #808080">-</span><span style="color: #000000">MON</span><span style="color: #808080">-</span><span style="color: #000000">RR<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_DATE_LANGUAGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AMERICAN<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_SORT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000ff">BINARY</span><span style="color: #000000"><br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_TIME_FORMAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HH.MI.SSXFF&nbsp;AM<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_TIMESTAMP_FORMAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DD</span><span style="color: #808080">-</span><span style="color: #000000">MON</span><span style="color: #808080">-</span><span style="color: #000000">RR&nbsp;HH.MI.SSXFF&nbsp;AM<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_TIME_TZ_FORMAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HH.MI.SSXFF&nbsp;AM&nbsp;TZR<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_TIMESTAMP_TZ_FORMAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DD</span><span style="color: #808080">-</span><span style="color: #000000">MON</span><span style="color: #808080">-</span><span style="color: #000000">RR&nbsp;HH.MI.SSXFF&nbsp;AM&nbsp;TZR<br><img src="https://i-blog.csdnimg.cn/blog_migrate/f0cd6c7f9e7ae96feae062cb48f670f0.gif" align="top" alt="">NLS_DUAL_CURRENCY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<script type="math/tex" id="MathJax-Element-1">
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               ZHS16GBK
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD - MON - RR
NLS_DATE_LANGUAGE              AMERICAN
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              </script>
NLS_COMP                        BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION               10.2 . 0.1 . 0
 
20  rows selected

          

     Note:

      需要注意，三个参数具有优先级关系，其中 Session Parameters 的优先级

      最高，优先启用 Session 级别所设置的参数。

      SESSION > INSTANCE > DATABASE

标签: Oracle, Concept

好文要顶 关注我 收藏该文

hallo
关注 - 1
粉丝 - 22

+加关注

0

0

« 上一篇： USERENV-SQLRef
» 下一篇： Oracle Release Number