/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 vote138 views1 answer
Create column that already exists mysql
SQL
5 votes137 views3 answers
String concatenation sql server
SQL
0 vote132 views1 answer
Change date format in oracle query
SQL
4 votes166 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote145 views1 answer
EnvironmentError: mysql_config not found
SQL
1 vote159 views1 answer
Is sql fast
SQL
0 vote141 views1 answer
Oracle query to find schema you are working on
SQL
0 vote136 views3 answers
Condition in count sql
SQL
0 vote135 views1 answer
Sql server user permissions and roles
SQL
0 vote200 views1 answer
Sql delete row from table where id
SQL