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

28 votes264 views6 answers
Foreign key
SQL
3 votes187 views2 answers
WhereIn SQL
SQL
6 votes175 views3 answers
Update with inner join postgres
SQL
16 votes235 views6 answers
Mysql find duplicates in same table
SQL
15 votes201 views5 answers
Select all tables sql
SQL
15 votes171 views1 answer
Mysql int range
SQL
8 votes203 views2 answers
Select current_timestamp - interval '3 days';
SQL
19 votes283 views5 answers
Mysql between date range
SQL
17 votes181 views3 answers
How to change a collumn name in sql
SQL
21 votes169 views5 answers
Oracle all tables
SQL