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

11 votes118 views6 answers
Distinct sql
SQL
0 vote140 views2 answers
Plpgsql
SQL
2 votes116 views3 answers
How to pass password mysql command line
SQL
0 vote133 views3 answers
Mysqli count down
SQL
1 vote114 views1 answer
Update from table tsql
SQL
4 votes128 views2 answers
Bulk kill mysql processlist
SQL
0 vote126 views1 answer
Mysql check datetime equals date
SQL
1 vote121 views1 answer
Oracle index partition
SQL
0 vote114 views1 answer
Calculate age in sql
SQL
11 votes128 views2 answers
How to import mysql database command line
SQL