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 vote174 views4 answers
First max salary in sql
SQL
0 vote215 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote192 views1 answer
SQL Integer devision
SQL
1 vote188 views1 answer
Display total number of tables in mysql
SQL
3 votes202 views2 answers
How to delete git repo locally
SQL
1 vote232 views1 answer
Sql comment header
SQL
10 votes182 views1 answer
Oracle dba_dependencies
SQL
3 votes208 views4 answers
Psql list tables in schema
SQL
3 votes186 views1 answer
Insert into table from another table mysql
SQL
1 vote181 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL