How to find the character set the database is using

To find the character set the Oracle database is using, the query is:

select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

PARAMETER                 VALUE
--------------------------------------------

NLS_CHARACTERSET         AL32UTF8
NLS_NCHAR_CHARACTERSET          AL16UTF16

More Oracle DBA tips, please visit Oracle DBA Tips