/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

4 votes176 views2 answers
Bulk kill mysql processlist
SQL
0 vote168 views1 answer
Drop all procedures sql server
SQL
0 vote164 views1 answer
No suitable driver found for sqlite
SQL
0 vote170 views1 answer
Denormalise SQL command
SQL
3 votes162 views1 answer
Sql cast to integer
SQL
1 vote181 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote175 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote214 views1 answer
Pl sql join 3 tables
SQL
1 vote173 views2 answers
Sql multiline comment
SQL
1 vote191 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL