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 vote205 views1 answer
Create synonym for dblink in oracle
SQL
10 votes192 views4 answers
Join with multiple conditions sql
SQL
0 vote195 views1 answer
Drop constraint in ms sql
SQL
6 votes253 views2 answers
Subtr Oracle ?
SQL
4 votes201 views2 answers
How to count items with same name in sql
SQL
0 vote221 views1 answer
Hour differeence in mysql
SQL
4 votes201 views1 answer
Mysql timestamp in laravel migration
SQL
3 votes193 views1 answer
What is having clause
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
2 votes222 views3 answers
Sql delete duplicate
SQL