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 vote291 views1 answer
Mysql select statement after index
SQL
4 votes301 views2 answers
Linq join
SQL
0 vote307 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
5 votes342 views2 answers
How to ascending order in sql
SQL
2 votes333 views1 answer
Install postgresql centos 5
SQL
0 vote288 views1 answer
How to select even id in sql
SQL
23 votes327 views5 answers
Sql substring
SQL
0 vote293 views1 answer
Oracle current timestamp
SQL
0 vote315 views1 answer
Min:sec datediff mssql
SQL
0 vote272 views1 answer
How to to get current date and time in sql
SQL