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 vote291 views1 answer
Print sum of values sql
SQL
5 votes374 views4 answers
SQL Order of execution
SQL
3 votes368 views1 answer
Laravel paginate raw sql
SQL
0 vote376 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote319 views3 answers
Mysqli count down
SQL
0 vote349 views1 answer
Sql how to get courses that i have made prerequisites
SQL
3 votes350 views4 answers
Ubuntu stop mysql
SQL
0 vote313 views1 answer
Sqlserver now
SQL
10 votes364 views2 answers
Tsql merge example
SQL
5 votes341 views1 answer
Invalid column name sql
SQL