SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to remove white spaces from table column

mradul goyalDec 31 2014 — edited Dec 31 2014

Hi all,

I am trying to remove white space from a table column and using ltrim(), rtrim(), replace() function to do so.

but it is not working and the problem is remaining the same giving me error of invalid number while trying a conversion on the column values.

So please suggest me if there is others ways to remove white spaces from column.

Thanks !

This post has been answered by Karthick2003 on Dec 31 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 28 2015

Added on Dec 31 2014

8 comments

28,994 views