Unable To Remove Trailing Spaces In A Column of a Table
(Doc ID 2507495.1)
Last updated on JANUARY 29, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
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