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

6 votes329 views5 answers
Alter table oracle
SQL
0 vote349 views1 answer
Sql server alter table add column tinyint
SQL
0 vote310 views1 answer
Insert or update cassandra
SQL
16 votes331 views2 answers
Add column to all tables after first column mysql
SQL
0 vote333 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote384 views1 answer
Postgres - Login and connect as default user
SQL
1 vote364 views1 answer
Get current date in pyspark sql
SQL
0 vote320 views1 answer
Write sql query to show the details start from digit
SQL
-1 vote327 views2 answers
Get day in sql
SQL
26 votes334 views2 answers
Mysql workbench download
SQL