View Source

To find out the current DB charset of an Oracle database:
How to check character set in Oracle:

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

Alternate source:

SELECT *
FROM v$nls_parameters
WHERE parameter LIKE '%CHARACTERSET'