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

2 votes275 views1 answer
SQL column name Postgre
SQL
0 vote279 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote295 views1 answer
Left join vs inner join performance
SQL
2 votes331 views1 answer
Find column in all stored procedures sql server
SQL
0 vote320 views1 answer
Traccar mysql
SQL
2 votes284 views1 answer
Oracle percentage
SQL
2 votes289 views1 answer
How to get non distinct values in sql
SQL
-2 votes299 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote299 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote311 views1 answer
Cube oracle
SQL