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

5 votes142 views2 answers
Oracle rename table
SQL
1 vote139 views1 answer
Sql find column name like
SQL
0 vote147 views2 answers
Amazon linux postgresql client
SQL
1 vote132 views1 answer
Postgres concat_ws
SQL
0 vote135 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote139 views1 answer
Select distinct after join
SQL
2 votes133 views3 answers
Mysql list tables by size
SQL
0 vote125 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote89 views2 answers
Sql query unique
SQL
0 vote121 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL