/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 vote139 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote187 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
-1 vote184 views1 answer
Ssql to lowercqse
SQL
6 votes258 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote178 views1 answer
Postgresql alter column nullable
SQL
2 votes180 views1 answer
Drop table if exists in postgres
SQL
3 votes231 views2 answers
How to View column names of a table in SQL
SQL
-1 vote198 views1 answer
Mysql select count if contains
SQL
1 vote139 views1 answer
Flask-sqlalchemy filter_by contains
SQL
4 votes204 views2 answers
Oracle unlock account
SQL