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

0 vote182 views1 answer
Do you know sql
SQL
0 vote139 views1 answer
Get rows from 1 table with other table empty mysql
SQL
9 votes186 views6 answers
Replace sql
SQL
12 votes139 views5 answers
Rename table in mysql
SQL
0 vote136 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote123 views1 answer
Sql server 2012 query history
SQL
0 vote144 views2 answers
Postgresql variable in query
SQL
0 vote136 views1 answer
Mysql replication change database name
SQL
0 vote142 views2 answers
Plsql function that return a table
SQL
0 vote139 views1 answer
Sql query wordpress export post
SQL