/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 vote336 views2 answers
Dumping sql table
SQL
0 vote312 views1 answer
Group by sql not ordering issues
SQL
0 vote319 views1 answer
Select all columns except one sql
SQL
5 votes364 views2 answers
How to ascending order in sql
SQL
0 vote320 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote316 views1 answer
Postgresql remove new line from string
SQL
1 vote303 views1 answer
Mysql history command
SQL
0 vote315 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote307 views1 answer
Sql server count all tables rows
SQL
0 vote336 views1 answer
Migration graphql
SQL