Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to view the character set of the database". In the daily operation, I believe that many people have doubts about how to view the character set of the database. The editor consulted all kinds of data and sorted out a simple and easy-to-use method of operation. I hope it will be helpful to answer the question of "how to view the character set of the database"! Next, please follow the editor to study!

View through the data dictionary

SYS@hyyk > select * from v$nls_parameters

PARAMETER VALUE

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_CURRENCY $

NLS_ISO_CURRENCY AMERICA

NLS_NUMERIC_CHARACTERS.

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT yyyy-mm-dd hh34:mi:ss

NLS_DATE_LANGUAGE AMERICAN

NLS_CHARACTERSET AL32UTF8

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_NCHAR_CHARACTERSET AL16UTF16

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

two。 The database character set information is stored in a dictionary table props$ from which we can obtain

-version 11.2

SYS@hyyk > select distinct dbms_rowid.rowid_relative_fno (rowid) file# from props$

FILE#

-

one

SYS@hyyk > select distinct dbms_rowid.rowid_block_number (rowid) blk# from props$

BLK#

-

eight hundred and one

[oracle@pc6 ~] $dd if=/u01/app/oracle/oradata/hyyk/system01.dbf of=hyyk bs=8192 skip=801 count=1

[oracle@pc6 ~] $strings hyyk

GLOBAL_DB_NAME

HYYK

Global database name

DBTIMEZONE

00:00

DB time zone

NO_USERID_VERIFIER_SALT 8BF56230FC49D6ECFE53EB96A5922DD5

WORKLOAD_REPLAY_MODE

BPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress

WORKLOAD_CAPTURE_MODE

/ CAPTURE implies workload capture is in progress

EXPORT_VIEWS_VERSION

Export views revision #

DEFAULT_PERMANENT_TABLESPACE

USERS$Name of default permanent tablespace

GLOBAL_DB_NAME

SEEDDATA

Global database name

NLS_RDBMS_VERSION

11.2.0.1.0 RDBMS version for NLS parameters

NLS_NCHAR_CHARACTERSET AL16UTF16

NCHAR Character set

NLS_NCHAR_CONV_EXCP

FALSE

NLS conversion exception

NLS_LENGTH_SEMANTICS

BYTE

NLS length semantics

NLS_COMP

BINARY

NLS comparison

NLS_DUAL_CURRENCY

Dual currency symbol

NLS_TIMESTAMP_TZ_FORMAT

DD-MON-RR HH.MI.SSXFF AM TZR

Timestamp with timezone format

NLS_TIME_TZ_FORMAT

HH.MI.SSXFF AM TZR

Time with timezone format

NLS_TIMESTAMP_FORMAT

DD-MON-RR HH.MI.SSXFF AM

Time stamp format

NLS_TIME_FORMAT

HH.MI.SSXFF AM

Time format

NLS_SORT

BINARY

Linguistic definition

NLS_DATE_LANGUAGE

AMERICAN

Date language

NLS_DATE_FORMAT DD-MON-RR

Date format

NLS_CALENDAR GREGORIAN

Calendar system

NLS_CHARACTERSET

AL32UTF8

Character set

NLS_NUMERIC_CHARACTERS

Numeric characters

NLS_ISO_CURRENCY

AMERICA

ISO currency

NLS_CURRENCY

Local currency

NLS_TERRITORY

AMERICA Territory

NLS_LANGUAGE

AMERICAN

Language

DEFAULT_TBS_TYPE SMALLFILE

Default tablespace type

DST_SECONDARY_TT_VERSION

0'Version of secondary timezone data file

DST_PRIMARY_TT_VERSION

11%Version of primary timezone data file

DST_UPGRADE_STATE

NONE&State of Day Light Saving Time Upgrade

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.