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

7 votes110 views3 answers
Select latest entry in sql table
SQL
1 vote101 views1 answer
Oracle get current schema
SQL
1 vote113 views2 answers
Procedure syntax
SQL
0 vote114 views1 answer
Hour and minute between two datatime sql
SQL
0 vote115 views1 answer
Mysql drop vs delete
SQL
0 vote107 views1 answer
Sql select upcoming birthdays
SQL
0 vote150 views1 answer
How to update random rows in sql
SQL
0 vote97 views1 answer
Vbscript create ADODB.Connection
SQL
3 votes102 views3 answers
Mysqldump: couldn
SQL
5 votes98 views4 answers
Rollback to in sql
SQL