天天看點

props$ of oracle 10g

  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/,如需轉載,請注明出處,否則将追究法律責任。

轉載于:http://blog.itpub.net/62429/viewspace-580538/