NLS_NCHAR_CHARACTERSET

-- NLS_CHARACTERSET for VARCHAR2, NLS_NCHAR_CHARACTERSET for NVARCHAR2
-- National Character Set
SELECT * FROM database_properties WHERE PROPERTY_NAME
    IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
SELECT * FROM nls_database_parameters WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET';
SELECT * FROM v$nls_parameters WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET';

Source: support.oracle.com

Similar codes

1 vote149 views1 answer
Mysql date diff in seconds
SQL
3 votes146 views1 answer
Two select sql
SQL
16 votes181 views3 answers
Order by sql query
SQL
0 vote169 views1 answer
Sql server rtrim everything after character
SQL
0 vote148 views1 answer
Hive batch drop table
SQL
0 vote148 views1 answer
How to to get current date in sql
SQL
1 vote141 views1 answer
Mysql select month and year
SQL
0 vote158 views1 answer
Where date in datetime mysql
SQL
4 votes148 views4 answers
Sqlite describe table
SQL
0 vote179 views1 answer
Sp help text in postgresql
SQL