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

1 vote317 views2 answers
Sql left characters
SQL
0 vote333 views1 answer
Generate random & unique mysql string
SQL
0 vote337 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote314 views2 answers
How to display enum value sql server
SQL
4 votes360 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote330 views1 answer
Sql script get all stored procedures from database
SQL
0 vote340 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote319 views1 answer
Postgresql escape single quote
SQL
0 vote344 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote311 views1 answer
How to user id to show in from date to upto date in mssql server
SQL