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

1 vote252 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
2 votes301 views1 answer
SQL IF ELSE
SQL
0 vote302 views1 answer
Mysql return column names when table is empty
SQL
1 vote301 views1 answer
Mysql dump specific tables
SQL
0 vote308 views1 answer
Vowels in sql
SQL
1 vote328 views1 answer
Altrer name column postgres
SQL
1 vote342 views1 answer
Postgresql if 0 then 1
SQL
4 votes325 views5 answers
Get last query in codeigniter 4
SQL
0 vote268 views1 answer
Mysql timeout 30 seconds
SQL
0 vote284 views1 answer
How to count with except in psql
SQL