National Language Support (NLS)

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023November 12, 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, 2023November 12, 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 »

How to Import Character Set Conversion

by Ed Chen
February 22, 2019April 19, 2023

Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there's NLS_LANG environment variable for user oracle… Read More »

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