NLS_LANGUAGE

NLS_SESSION_PARAMETERS, How and Why

by Ed Chen
July 18, 2023July 24, 2023

What is NLS_SESSION_PARAMETERS ? NLS_SESSION_PARAMETERS is a dictionary view which shows all current NLS parameters of an user's session. Let's see their values. SQL> set… Read More »

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023June 19, 2023

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

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 TO_CHAR Example

by Ed Chen
June 5, 2023August 28, 2023

TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »

NLS_LANGUAGE to NLS_TERRITORY Mapping Table

by Ed Chen
September 16, 2019December 10, 2022

NLS_LANGUAGE to NLS_TERRITORY Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this… Read More »

How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Language Only

NLS_LANGUAGE to NLS_DATE_FORMAT Mapping Table

by Ed Chen
September 14, 2019April 15, 2023

NLS_LANGUAGE to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_DATE_FORMAT. In some situations, you may need this… Read More »

Oracle NLS_LANGUAGE All Available List

by Ed Chen
September 8, 2019April 20, 2023

To retrieve all available NLS_LANGUAGE or NLS_DATE_LANGUAGE in Oracle, we execute the following query to get the list. SQL> select value "NLS_LANGUAGE" from v$nls_valid_values where… 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 »

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