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

15 votes136 views2 answers
Sql order by multiple columns
SQL
0 vote138 views1 answer
Mysql error 1251
SQL
2 votes129 views1 answer
Sqlite show table indexes
SQL
6 votes140 views2 answers
Where clause in sql
SQL
1 vote129 views1 answer
Check message id sql server
SQL
0 vote140 views1 answer
Php get closest location by latitude longitude
SQL
0 vote145 views1 answer
Select odd records sql
SQL
0 vote123 views1 answer
Change permission to database mysql
SQL
3 votes133 views1 answer
Get all elements sql
SQL
24 votes134 views6 answers
Replace mysql
SQL