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

2 votes230 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote260 views1 answer
Move table to a different schema
SQL
0 vote240 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
1 vote233 views2 answers
Mysql select tables with name like
SQL
0 vote227 views1 answer
How to avoid duplicate records in sqlite
SQL
9 votes240 views4 answers
Oracle get table column names
SQL
2 votes230 views1 answer
Anonymous block plsql
SQL
20 votes228 views4 answers
Reset auto increment in MySQL
SQL
5 votes239 views1 answer
JBDC
SQL
13 votes383 views4 answers
Sql joining 3 tables
SQL