Select nls characterset

This select shows how to select the used Character-Set in ORACLE

SELECT *
FROM V$NLS_PARAMETERS
WHERE parameter = 'NLS_CHARACTERSET';

PARAMETER VALUE
----------------- --------
NLS_CHARACTERSET AL32UTF8