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

5 votes265 views1 answer
Minecraft java port number
SQL
0 vote284 views1 answer
Migration graphql
SQL
8 votes283 views3 answers
SQL column name
SQL
2 votes286 views1 answer
Oracle insert or update
SQL
0 vote235 views1 answer
Sqlite3 now
SQL
-1 vote272 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote297 views2 answers
How to drop mili second in sql
SQL
0 vote266 views1 answer
Foreign key multiple columns
SQL
1 vote278 views1 answer
Sql select all from one table and one column from another
SQL
0 vote270 views3 answers
Classement rang mysql 7
SQL