Friday, October 26, 2012

check character set in Oracle

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

No comments:

Post a Comment