stored-procedures.com is a blog about databases created and mantained by Paulo Rocha an Oracle DBA.
Sunday, June 12, 2011
How to Check What NLS Characterset Oracle is Using
There are occasions when we what to verify what NLS character set our database is using. This can be accomplished very easly by either querying the NLS_DATABASE_PARAMETERS view, or the sys.props$ view.
Check nls character set by querying the sys.props$ view
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
Check nls character set by querying the NLS_DATABASE_PARAMETERS view