Oracle character set

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');

Source: grepper.com

Similar codes

0 vote303 views1 answer
Mysql date without time
SQL
1 vote280 views1 answer
Increasing font and zooming in mysql workbench
SQL
12 votes263 views1 answer
Create column sql server
SQL
0 vote280 views1 answer
Mysql group by range
SQL
1 vote255 views1 answer
Truncate table in postgresql and reset id
SQL
6 votes268 views4 answers
Sqlite drop table
SQL
0 vote277 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote260 views1 answer
Postgresql copy backup table
SQL
0 vote308 views1 answer
Table structure in sql
SQL
0 vote302 views1 answer
Offset in postgresql example
SQL