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

2 votes375 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote370 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
1 vote368 views3 answers
Rows, INSERT INTO
SQL
0 vote354 views1 answer
Db format in quotation
SQL
0 vote356 views1 answer
Raven ql select count
SQL
0 vote375 views1 answer
Add sqlcmd to path linux
SQL
0 vote381 views1 answer
Show all sequences postgres
SQL
2 votes414 views2 answers
Null column to 0 in mysql
SQL
0 vote396 views1 answer
Add user mysql wordpress
SQL
0 vote343 views2 answers
How to start postgresql laravel
SQL