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


SELECT * FROM NLS_DATABASE_PARAMETERS;