select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';

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


select * from nls_instance_parameters where parameter='NLS_LANGUAGE';