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

3 votes289 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote265 views1 answer
Sql server roles and users
SQL
1 vote257 views2 answers
Find a column in all tables mysql
SQL
0 vote273 views1 answer
Delete a record from a table sqlite3
SQL
0 vote268 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote272 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote259 views1 answer
Assign value to var in SQL
SQL
11 votes272 views1 answer
Get ddl materialized view oracle
SQL
0 vote294 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote283 views1 answer
DATEDIFF minute postgres
SQL