ITPub博客

首页 > Linux操作系统 > Linux操作系统 > props$ of oracle 10g

props$ of oracle 10g

原创 Linux操作系统 作者:worldli 时间:2009-03-29 20:12:51 0 删除 编辑

  1* select * from props$                                                                             
SQL> /                                                                                                
                                                                                                      
NAME                                   VALUE$                              COMMENT$                           
------------------------------      ----------------------------------- ------------------------------------
DICT.BASE                      2                                   dictionary base tables version #   
DEFAULT_TEMP_TABLESPACE        SYSTEM                              Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE   SYSTEM                              Name of default permanent tablespace
DBTIMEZONE                     +08:00                              DB time zone                       
DEFAULT_TBS_TYPE               SMALLFILE                           Default tablespace type            
NLS_LANGUAGE                   AMERICAN                            Language                           
NLS_TERRITORY                  AMERICA                             Territory                          
NLS_CURRENCY                   $                                   Local currency                     
NLS_ISO_CURRENCY               AMERICA                             ISO currency                       
NLS_NUMERIC_CHARACTERS         .,                                  Numeric characters                 
NLS_CHARACTERSET               UTF8                                Character set                      
                                                                                                      
NAME                           VALUE$                              COMMENT$                           
------------------------------ ----------------------------------- ------------------------------------
NLS_CALENDAR                   GREGORIAN                           Calendar system                    
NLS_DATE_FORMAT                DD-MON-RR                           Date format                        
NLS_DATE_LANGUAGE              AMERICAN                            Date language                      
NLS_SORT                       BINARY                              Linguistic definition              
NLS_TIME_FORMAT                HH.MI.SSXFF AM                      Time format                        
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM            Time stamp format                  
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR                  Time with timezone format          
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR        Timestamp with timezone format     
NLS_DUAL_CURRENCY              $                                   Dual currency symbol               
NLS_COMP                       BINARY                              NLS comparison                     
NLS_LENGTH_SEMANTICS           BYTE                                NLS length semantics               
                                                                                                      
NAME                           VALUE$                              COMMENT$                           
------------------------------ ----------------------------------- ------------------------------------
NLS_NCHAR_CONV_EXCP            FALSE                               NLS conversion exception           
NLS_NCHAR_CHARACTERSET         AL16UTF16                           NCHAR Character set                
NLS_RDBMS_VERSION              10.2.0.1.0                          RDBMS version for NLS parameters   
GLOBAL_DB_NAME                 WORLD                               Global database name               
EXPORT_VIEWS_VERSION           8                                   Export views revision #            
                                                                                                      
27 rows selected.                                                                                     
                                                                                                      
SQL>                                                                                                  

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/62429/viewspace-580538/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-29

  • 博文量
    1
  • 访问量
    2940