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

0 vote131 views1 answer
SQL server select to get sum of hours
SQL
0 vote162 views1 answer
Sqlcl format
SQL
1 vote147 views1 answer
Sql padd let with zeros
SQL
0 vote144 views1 answer
Redudancy in SQL
SQL
10 votes144 views2 answers
Show tables in schema oracle
SQL
0 vote164 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote144 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote135 views1 answer
Base nosql
SQL
3 votes130 views2 answers
Oracle synonym
SQL
10 votes139 views1 answer
Oracle object dependencies
SQL