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 vote138 views1 answer
Procedures sql insert mysql
SQL
0 vote130 views1 answer
Not between mysql
SQL
1 vote134 views2 answers
Regex starts with
SQL
3 votes152 views2 answers
Sqlite show table definition
SQL
5 votes130 views1 answer
How to get all dates in a month in oracle
SQL
0 vote135 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes142 views1 answer
Oracle list grants on procedure
SQL
0 vote182 views1 answer
Regex mongoose
SQL
1 vote168 views1 answer
Mysql default port
SQL
9 votes139 views1 answer
Identity insert on sql server
SQL