update mytable set mycolumn = trim(mycolumn)
I am using above query where mycolumn is of type char.
It trims the leading blank but not trailing.
I tried update mytable set mycolumn = TO_CHAR (trim(mycolumn))
But it didn't help either.
Can anyone help here?