NLS_CHARACTERSET

Oracle NLS_CHARACTERSET All Available List

by Ed Chen
September 10, 2019June 14, 2022

To retrieve all available NLS_CHARACTERSET in Oracle, we execute the following query to get the list. SQL> select value "NLS_CHARACTERSET" from v$nls_valid_values where parameter =… Read More »

NLS_LANG, How and Why

by Ed Chen
September 7, 2019March 22, 2023

In this post, I'll talk about 3 major topics about NLS_LANG. What is NLS_LANG? How to Set NLS_LANG in Oracle? What are Available Values of… Read More »

How Oracle Change Character Set

by Ed Chen
March 25, 2017December 11, 2022

Assuming that you have exported all the data to dump files for later processes. Database Character Set Check current setting on character sets. SQL> column… Read More »