How to Check Oracle Database Character Set

Many times you need to validate the Oracle database characterset, maybe because it is an old Oracle database that did not have UTF8 (which is the recommended charset) or maybe because someone created the database with a different charset for a given reason…

Anyways, here is how you can check the Oracle database characterset:

select *
from NLS_DATABASE_PARAMETERS
where parameter='NLS_CHARACTERSET';