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 vote265 views2 answers
Mysql output csv
SQL
0 vote287 views1 answer
Postegresql update to null
SQL
0 vote290 views1 answer
SQL column name Oracle
SQL
2 votes276 views2 answers
How to create an empty table from an existing table
SQL
1 vote276 views1 answer
Woocommerce mysql price table
SQL
4 votes298 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote286 views1 answer
Raiserror with nowait
SQL
0 vote326 views1 answer
Generate a random otp in sql server
SQL
0 vote284 views1 answer
WHERE not regex in SQL
SQL
1 vote284 views1 answer
How to start with sql
SQL