Results 1 to 2 of 2
Jul 21, 2013, 21:37 #1
- Join Date
- Nov 2011
- Kuching, Sarawak
- 0 Post(s)
- 0 Thread(s)
Oracle Update Column LTRIM and RTRIM
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.