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

3 votes138 views1 answer
Sql print all names that start with a given letter
SQL
16 votes139 views6 answers
Install sqlite3 python
SQL
1 vote137 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote187 views1 answer
Add week ending date sql server
SQL
1 vote140 views1 answer
SQL query to get all table records count from a database
SQL
0 vote202 views1 answer
How to add auto increment primary key
SQL
1 vote134 views1 answer
Wherein mysql
SQL
1 vote146 views2 answers
Reset mysqli fetch_arra
SQL
0 vote149 views2 answers
Sql max count
SQL
0 vote134 views1 answer
Oracle select invalid views
SQL