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] Message-----
From: Shepard, Wade [mailto:[Email Address Removed] 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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