Tag: check character set in Oracle

check character set in Oracle

Posted on by Osama Mustafa in Database
Simple Topic just to people who asked before why NLS_CHARACTER SET Not appearing in my V$PARAMETER View :

Just Use two Below Query Depend on your version 

SQL> select value from nls_database_parameters where 
parameter = 'NLS_CHARACTERSET' ;
 
VALUE
----------------------------------------
AR8MSWIN1256
 
 
Check the National Character set :
 
SQL> select value from nls_database_parameters where 
parameter = 'NLS_NCHAR_CHARACTERSET' ;

 Or you can Use :

SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ;

Thank you
Osama Mustafa