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

10 votes70 views1 answer
Dba_dependencies
SQL
0 vote83 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote77 views1 answer
Sql database connectivity
SQL
7 votes79 views4 answers
Lowest salary in sql
SQL
0 vote89 views1 answer
Sql filter rows with condition
SQL
3 votes84 views4 answers
Show databases in sql server
SQL
1 vote72 views1 answer
Load sql into mamp
SQL
0 vote86 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote80 views1 answer
GROUP BY postgres
SQL
1 vote81 views1 answer
Oracle grant on all tables in schema
SQL