NLS_LENGTH_SEMANTICS

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 »

How to Resolve ORA-28232: invalid input length for obfuscation toolkit

by Ed Chen
July 17, 2021June 4, 2022

ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »

How to Set NLS_LENGTH_SEMANTICS Temporarily

by Ed Chen
May 19, 2021December 17, 2021

NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »

How to Resolve ORA-12899: value too large for column

by Ed Chen
November 13, 2019December 10, 2022

ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. What… Read More »

BYTE vs CHAR in NLS_LENGTH_SEMANTICS

by Ed Chen
December 12, 2012March 21, 2023

BYTE vs CHAR in NLS_LENGTH_SEMANTICS Most of databases set NLS_LENGTH_SEMANTICS as BYTE by default, but there are some databases in Non-English country will take CHAR… Read More »

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