/SQL/How to know the character set of an oracle databes

How to know the character set of an oracle databes

select * from database_properties where PROPERTY_NAME in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')

Source: quora.com

How to know the character set of an oracle databes

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');

Similar codes

0 vote206 views2 answers
Sql if empty then
SQL
5 votes769 views1 answer
Oracle ora-00054 find
SQL
0 vote180 views1 answer
Sql reverse order of results
SQL
0 vote240 views1 answer
Mysql installer no packages found
SQL
1 vote189 views1 answer
How to print longest name in sql
SQL
0 vote209 views1 answer
Hashpass
SQL
0 vote183 views1 answer
Vbscript connect mssql
SQL
0 vote203 views1 answer
Oracle chain step succeeded
SQL
1 vote164 views1 answer
Select dba users oracle
SQL
0 vote181 views1 answer
Pip install mysqlclient error
SQL