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!

How to trim spaces in SQL?

stoneiidolMay 19 2010 — edited May 19 2010

Hi there,

I have installed Oracle XE on my machine and have populated it with some data. In one table,namely the Id column i noted there are spaces before the actual code. For example _ _ _12345. My question is, how do i removed these spaces? I am using Oracle SQL Developer to query the tables in XE. I have over 100,000 records.

Thanks for the help
SI

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 19 2010

4 comments

833 views