/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 votes304 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote306 views1 answer
Regular expression in sql server
SQL
0 vote305 views1 answer
How to insert a uniqueidentifier in sql
SQL
2 votes329 views1 answer
Mysql shell insert into
SQL
5 votes321 views1 answer
Sql integer to serial
SQL
1 vote280 views1 answer
Import database from a file using mysql commandline
SQL
0 vote273 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote305 views1 answer
Column ' ' in field list is ambiguous
SQL
2 votes287 views2 answers
How to get capital letter first in sql
SQL
0 vote302 views1 answer
C# add a textbox in mysql select
SQL