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 vote333 views1 answer
Mysql export search results
SQL
1 vote325 views1 answer
Rermove categories woocommerce sql
SQL
22 votes322 views3 answers
Join three tables sql
SQL
2 votes330 views1 answer
Sqlite insert if not exists
SQL
0 vote368 views1 answer
Combine 2 columns search query mysql
SQL
0 vote331 views1 answer
How to select an index in oracle sql
SQL
1 vote295 views1 answer
Foreign key in oracle sql developer
SQL
0 vote332 views1 answer
Select from column mysql
SQL
0 vote305 views1 answer
Get all employees if name ends with in sql
SQL
0 vote350 views1 answer
Prodection ready postgres database step by step
SQL