SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
VALUE$ -------------------------------- AL32UTF8
Or
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE parameter = 'NLS_CHARACTERSET';
PARAMETER VALUE --------------------------------------- NLS_CHARACTERSET AL32UTF8