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

0 vote160 views1 answer
Sql include rows with 0 values
SQL
1 vote180 views2 answers
Mysql does sentance contain word
SQL
0 vote147 views1 answer
Mysql case when null
SQL
1 vote145 views1 answer
How to get mysql db size
SQL
0 vote168 views1 answer
Get last updated row sql server
SQL
2 votes167 views1 answer
Capitalize 1st letter in sql server
SQL
1 vote166 views1 answer
Oracle sql pad left zeros
SQL
3 votes158 views2 answers
Oracle for loop
SQL
0 vote152 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote154 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL