My Oracle Support Banner

Unable To Remove Trailing Spaces In A Column of a Table (Doc ID 2507495.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

We are not able to remove trailing space on this particular column and value (‘LC ’). Manual RTRIM update is also not working.

UPDATE XX.tab1 SET Col1=RTRIM(Col1) WHERE Col1 LIKE 'LC%'

Col1 is CHAR data type
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.