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

0 vote121 views1 answer
Mssql + bit + in python orm
SQL
0 vote121 views1 answer
How to get one year old query from plan cache
SQL
2 votes99 views2 answers
Join update query in sql
SQL
0 vote103 views1 answer
What is between keyword used for
SQL
0 vote96 views1 answer
Sql examples from your work
SQL
0 vote114 views1 answer
Postgres 11 add primary key
SQL
0 vote109 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
1 vote129 views1 answer
Select inside insert query
SQL
0 vote117 views1 answer
Alter rename command in mysql
SQL
0 vote101 views1 answer
Min and max salary and name in sql
SQL