Hi there,
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.
Any ideas?