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 vote209 views1 answer
Oracle list chain steps
SQL
4 votes224 views2 answers
Postgresql reset sequence
SQL
0 vote240 views1 answer
Mssql disable foreign key constraint
SQL
4 votes227 views3 answers
Rename table column postgresql
SQL
14 votes249 views4 answers
Sql compiler
SQL
0 vote234 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote220 views1 answer
Mssql current date
SQL
3 votes234 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
7 votes238 views1 answer
Mysql remote connection command line
SQL
6 votes218 views1 answer
What is where clause in sql
SQL