查看oracle系统的字符集

最新推荐文章于 2023-09-18 01:19:03 发布

原创最新推荐文章于 2023-09-18 01:19:03 发布 · 627 阅读

1 ·

CC 4.0 BY-SA版权

oracle 日常运维的各种脚本专栏收录该内容

51 篇文章

订阅专栏

13:25:39 sys@tppaml> col parameter for a40
13:25:45 sys@tppaml> col value for a40
13:25:51 sys@tppaml> select * from     nls_database_parameters;

PARAMETER                                VALUE
---------------------------------------- ----------------------------------------
NLS_NCHAR_CHARACTERSET                   AL16UTF16
NLS_LANGUAGE                             AMERICAN
NLS_TERRITORY                            AMERICA
NLS_CURRENCY                             $
NLS_ISO_CURRENCY                         AMERICA
NLS_NUMERIC_CHARACTERS                   .,
NLS_CHARACTERSET                         AL32UTF8
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                        $
NLS_COMP                                 BINARY
NLS_LENGTH_SEMANTICS                     BYTE
NLS_NCHAR_CONV_EXCP                      FALSE
NLS_RDBMS_VERSION                        11.2.0.4.0