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

9 votes99 views2 answers
Default number in sql
SQL
0 vote116 views1 answer
SQL: calculate hours from two dates
SQL
1 vote114 views1 answer
Calculate age in sql postgresql
SQL
0 vote99 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote105 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote117 views1 answer
Sql server rtrim everything after character
SQL
0 vote125 views1 answer
Sqlalchemy empty table
SQL
0 vote102 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote115 views1 answer
Sql query to find duplicate email address
SQL
9 votes103 views1 answer
Identity insert on sql server
SQL