This also works from a v$ view


select * from v$nls_parameters where parameter=NLS_CHARACTERSET;

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

HTHU

Ankur Shah
Oracle DBA
DHR-GA


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


| This info is located in sys.props$
|
| Use this statement.
|
| select *
| from sys.props$
| where name='NLS_CHARACTERSET';
|
| Hope this helps!
|
| Eric W. Diehl
| Sr. Database Administrator
| Fleet Credit Card Services
| Phone: 215.444.7158
| Cell: 215.768.7527
| Pager: [Email Address Removed]
|
| -----Original Message-----
| From: Shepard, Wade [mailto:[Email Address Removed] Sent: Thursday, May 30, 2002 2:23 PM
| To: LazyDBA.com Discussion
| 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 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