Oracle character set

SELECT * FROM nls_database_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
SELECT * FROM v$nls_parameters WHERE PARAMETER = 'NLS_CHARACTERSET';
-- NLS_CHARACTERSET for VARCHAR2, NLS_NCHAR_CHARACTERSET for NVARCHAR2
SELECT * FROM database_properties WHERE PROPERTY_NAME
    IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');

Source: grepper.com

Similar codes

2 votes327 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote329 views1 answer
Using distinct and count together in sql
SQL
0 vote317 views1 answer
Jdbc sql connection string
SQL
1 vote342 views1 answer
Postgresql how to show table names
SQL
8 votes321 views1 answer
Show mysql user table
SQL
0 vote337 views1 answer
Sql show table name in result
SQL
14 votes378 views6 answers
Finding duplicate rows mysql
SQL
0 vote301 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote309 views1 answer
T-SQL Alter the column data type
SQL
0 vote336 views3 answers
Create and attach user to a postgresql database
SQL