Yes :

=================================================

[Email Address Removed] TEST> 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 DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET US7ASCII
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
---------------------------------------------------------------- --------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM T
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_COMP BINARY

===================================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "Shepard, Wade" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, May 30, 2002 2:23 PM
Subject: How Do I determine Database character set?


|
|
| I just recently did the following command
|
| SVRMGR> ALTER DATABASE CHARACTER SET UTF8;
|
| I know there is a V$ for NLS_CHARACTER SET is there on for Database
| Character set?
|
|
| --------
| Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these terms:http://www.lazydba.com/legal.html
|
Oracle LazyDBA home page