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

15 votes172 views2 answers
Select where duplicate mysql
SQL
1 vote181 views1 answer
Postgresql filter on
SQL
26 votes170 views2 answers
What is the sql statement that finds duplicate usernames
SQL
2 votes185 views2 answers
How to add not null constraint in sql
SQL
1 vote167 views1 answer
Oracle difference between two dates in years
SQL
0 vote169 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote171 views1 answer
Oracle service name view
SQL
16 votes223 views6 answers
Mysql find duplicates in same table
SQL
0 vote206 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote168 views1 answer
Postgresql substring last
SQL