/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

1 vote128 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote106 views1 answer
Mysql use password error
SQL
1 vote115 views1 answer
Loading local data is disabled mysql
SQL
1 vote122 views1 answer
Pgsql sum switch case
SQL
1 vote114 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote110 views1 answer
Sqlite closes value
SQL
16 votes121 views1 answer
Mssql int max value
SQL
13 votes117 views3 answers
Uninstall mysql centos 7
SQL
0 vote111 views1 answer
Uuid sqlalcomany
SQL
1 vote132 views1 answer
How to put value in variable mysql
SQL