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 vote373 views1 answer
Get total and distict row diff in sql
SQL
0 vote347 views1 answer
Print mysql
SQL
0 vote333 views1 answer
Update database collation in postgresql
SQL
0 vote376 views1 answer
Sql constarint
SQL
32 votes363 views6 answers
Insert select
SQL
5 votes318 views2 answers
Ranking functions in sql
SQL
0 vote351 views1 answer
Postgres row expiration
SQL
1 vote333 views1 answer
SQL server query column yes or no
SQL
0 vote349 views1 answer
Bidirectional outer join sql
SQL
1 vote335 views2 answers
T sql get foreign key
SQL