V$NLS_VALID_VALUES

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 »

Oracle NLS_TERRITORY All Available List

by Ed Chen
September 9, 2019June 14, 2022

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

Oracle NLS_LANGUAGE All Available List

by Ed Chen
September 8, 2019June 14, 2022

To retrieve all available NLS_LANGUAGE in Oracle, we execute the following query to get the list. SQL> select value "NLS_LANGUAGE" 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 »