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 votes210 views1 answer
Oracle convert run_duration to number
SQL
0 vote202 views2 answers
Update all columns in one update
SQL
0 vote212 views1 answer
How to get one year old query from plan cache
SQL
1 vote204 views1 answer
Oracle rolling back transactions
SQL
1 vote192 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote211 views1 answer
Power bi dax add related shows column but not working
SQL
9 votes227 views3 answers
Mysql run sql file
SQL
0 vote241 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes196 views1 answer
Oracle kill job by sid
SQL
4 votes204 views1 answer
Oracle delete last row
SQL