|
|
Re: Charater sets usage in oracle [message #277608 is a reply to message #277605] |
Tue, 30 October 2007 14:42 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
1* select PROPERTY_NAME,PROPERTY_VALUE from database_properties
SQL> /
PROPERTY_NAME PROPERTY_VALUE
------------------------------ ------------------------------
DICT.BASE 2
DEFAULT_TEMP_TABLESPACE DS_TEMP
DEFAULT_PERMANENT_TABLESPACE DS_USER
DBTIMEZONE +00:00
DEFAULT_TBS_TYPE BIGFILE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
PROPERTY_NAME PROPERTY_VALUE
------------------------------ ------------------------------
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
PROPERTY_NAME PROPERTY_VALUE
------------------------------ ------------------------------
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.3.0
GLOBAL_DB_NAME DS.OMZESP07.MCILINK.COM
EXPORT_VIEWS_VERSION 8
27 rows selected.
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a67789/ch1.htm
|
|
|
|
|