Oracle NLS_CHARACTERSET

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

27 votes189 views6 answers
Sql update record
SQL
0 vote188 views1 answer
Mariadb cast null to 0
SQL
1 vote171 views1 answer
Mysql show data from table
SQL
19 votes165 views6 answers
Laravel sql query
SQL
56 votes339 views5 answers
Psql create user
SQL
0 vote167 views1 answer
Narural join
SQL
0 vote194 views2 answers
Postgresql gset
SQL
0 vote183 views1 answer
Teller stamp , bmo , PDF
SQL
2 votes180 views2 answers
How to check database username and password in postgresql
SQL
0 vote172 views1 answer
How to see the query of a view in mysql
SQL