/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

6 votes234 views2 answers
If not exists insert sql
SQL
0 vote223 views1 answer
Mysql change timestamp on update
SQL
1 vote204 views1 answer
Can we drop a primary key
SQL
6 votes250 views2 answers
Mysql timestamp to date
SQL
6 votes220 views1 answer
How to count number of rows in sql
SQL
0 vote224 views1 answer
Mysql could not fetch tables
SQL
0 vote241 views1 answer
How to convert external table to managed table in hive
SQL
3 votes230 views2 answers
Mysql create timestamp column
SQL
0 vote218 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
-1 vote219 views1 answer
How to check table exists or not in postgresql
SQL