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 vote350 views1 answer
Tsql pad left
SQL
0 vote338 views1 answer
Add colum date in sql
SQL
29 votes348 views5 answers
Mysql show table structure
SQL
5 votes400 views1 answer
Mysql count lines
SQL
1 vote343 views2 answers
Sql select only first occurrence
SQL
3 votes336 views4 answers
Mysql create table from select statement
SQL
0 vote320 views1 answer
Clone table structure mysql
SQL
14 votes358 views2 answers
Install mysqldump
SQL
0 vote331 views1 answer
Sql remove last x char
SQL
0 vote376 views1 answer
Local pg_sql to heroku pg_sql
SQL