Oracle NLS_CHARACTERSET

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');

Similar codes

0 vote217 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote241 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
5 votes223 views3 answers
String concatenation sql server
SQL
0 vote222 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote225 views1 answer
Copy data from cell to cell mysql
SQL
1 vote203 views2 answers
Into sql
SQL
-2 votes240 views2 answers
Union vs union all in sql
SQL
31 votes218 views3 answers
Sql count
SQL
0 vote241 views1 answer
Postgres list all stored procedures query
SQL
0 vote233 views2 answers
Laravel: customize or extend notifications - database model
SQL