Oracle character set

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');

Source: grepper.com

Similar codes

0 vote129 views1 answer
Mssql unique key accept nulls
SQL
5 votes138 views1 answer
How to get all table names in sql query
SQL
13 votes100 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote76 views1 answer
Java spring boot connect to sql server
SQL
3 votes127 views2 answers
Postgresql select all column names
SQL
1 vote78 views1 answer
Unique vs distinct sql
SQL
20 votes116 views4 answers
Sqlite create table if not exists
SQL
0 vote117 views1 answer
Gcloud check sql
SQL
10 votes84 views2 answers
Sql where clause multiple values
SQL
1 vote75 views2 answers
Get date from datetime postgresql
SQL