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 vote351 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote392 views1 answer
Create synonym for dblink in oracle
SQL
0 vote403 views1 answer
Python dictionary to sql update
SQL
-2 votes360 views1 answer
How to open database
SQL
-1 vote391 views1 answer
Pl/sql how to delete a trigger
SQL
1 vote388 views1 answer
Oracle sql first day of year
SQL
13 votes562 views4 answers
Sql joining 3 tables
SQL
0 vote368 views1 answer
Sql get date from timestamp
SQL
0 vote376 views2 answers
Starts and end with vowel sql
SQL
0 vote357 views1 answer
T-SQL - Where Used List (Table/View)
SQL