I am wish to update my database data in SQL Developer using
"UPDATE TABLE_NAME SET COLUMN_NAME = LTRIM(RTRIM(COLUMN_NAME))".
But it does not take any effect even the msg of "rows updated" is displayed. The leading and trailing white spaces still exist behind every strings.
maybe they're not spaces but rather some other unprintable character
This topic is now closed. New replies are no longer allowed.