NLS_CHARACTERSET

NLS_DATABASE_PARAMETERS, How and Why

by Ed Chen
July 14, 2023June 19, 2023

What is NLS_DATABASE_PARAMETERS ? NLS_DATABASE_PARAMETERS is a dictionary view which shows default NLS parameters of a database. Let's see their values. SQL> set pagesize 1000;… Read More »

Oracle NLS_CHARACTERSET All Available List

by Ed Chen
September 10, 2019April 20, 2023

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, 2019April 26, 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 »

JavaScript is not enabled. Please enable it and reload the page.