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 laterInformation 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 |