Code:
UPDATE your_table SET your_col = SUBSTR(your_col,1,LENGTH(your_col)-1);
Sanjay