How to Determine Oracle Database Character Set

You can find the Oracle database character set by following command,

SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

The output

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               WE8DEC

You May Also Like

Leave a Reply?