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 votes117 views1 answer
Pl sql check if variable is empty
SQL
5 votes120 views1 answer
How to check nls format in oracle
SQL
4 votes131 views1 answer
Mysql ip address data type
SQL
37 votes124 views3 answers
Postgresql insert column
SQL
0 vote130 views1 answer
Const pool = mysql.createpool()
SQL
0 vote125 views1 answer
What is SQL data store?
SQL
0 vote122 views1 answer
How to declare variable date in mysql
SQL
0 vote120 views1 answer
Postgresql delete multiple rows
SQL
0 vote105 views2 answers
Postgresql display subquery as json
SQL
0 vote130 views1 answer
Sql query for select from specific columns in a table
SQL