/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

2 votes202 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes186 views2 answers
Update all rows mysql
SQL
8 votes205 views1 answer
Check mysql version phpmyadmin
SQL
1 vote186 views4 answers
Fatal database postgres does not exist
SQL
10 votes207 views4 answers
Primary key in sql
SQL
0 vote200 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote191 views1 answer
Oracle sql alter view add column
SQL
0 vote197 views1 answer
Top frequency in sql server
SQL
0 vote191 views1 answer
How to install mysql without admin rights
SQL
-1 vote181 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL