/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

5 votes140 views4 answers
Mysql update column with value from another table
SQL
0 vote141 views1 answer
Querry mysql by 2 columns
SQL
1 vote135 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote138 views1 answer
Sql change primary key to composite key
SQL
0 vote137 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote137 views1 answer
SAP Return
SQL
4 votes145 views1 answer
Oracle user tables
SQL
0 vote165 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote143 views1 answer
Plsql find location of procedure
SQL
0 vote147 views1 answer
How to add unique key constraint in mysql
SQL