SQL> select * from NLS_DATABASE_PARAMETERS;
PARAMETER VALUE
------------------------------ ---------------
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_NCHAR_CHARACTERSET UTF8
PARAMETER VALUE
------------------------------ ---------------
NLS_SAVED_NCHAR_CS WE8ISO8859P1
NLS_TIME_FORMAT HH.MI.SSXFF AM
(OR)
SQL> select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------------ ---------------
NLS_CHARACTERSET AL32UTF8
The database character set in oracle determines the set of characters can be stored in the database. It is also used to determine the character set to be used for object identifiers and PL/SQL variables and for storing PL/SQL program source.
PARAMETER VALUE
------------------------------ ---------------
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_NCHAR_CHARACTERSET UTF8
PARAMETER VALUE
------------------------------ ---------------
NLS_SAVED_NCHAR_CS WE8ISO8859P1
NLS_TIME_FORMAT HH.MI.SSXFF AM
(OR)
SQL> select * from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------------ ---------------
NLS_CHARACTERSET AL32UTF8
The database character set in oracle determines the set of characters can be stored in the database. It is also used to determine the character set to be used for object identifiers and PL/SQL variables and for storing PL/SQL program source.
No comments:
Post a Comment