URGENT how to find character set ?

Hello gurus..

9.0.1...

How do i find out the character set in a database ?...

thanks
ron

select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'

There are other ways to check.

Code:

---

SQL> desc nls_database_parameters
Name                                    Null?    Type
--------------------------------------- -------- -------------
PARAMETER                              NOT NULL VARCHAR2(30)
VALUE                                            VARCHAR2(40)

---

How do I find which settings I currently have for NLS features?

NLS_DATABASE_PARAMETERS - defaults set up for the database at creation

NLS_SESSION_PARAMETERS - parameters set by NLS_LANG or alter session (does not include client character set)

NLS_INSTANCE_PARAMETERS - parameters set in init.ora

V$NLS_PARAMETERS - values of NLS parameters for current values

V$NLS_VALID_VALUES - values which can be used for CHARACTERSET, LANGUAGE, TERRITORY, SORT (dependent on what was loaded at install time)