Skip to Main Content
Forums

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 remove extra space in between a string?

533993May 9 2010 — edited Jun 10 2010
How to remove the extra space in between the string?


Ex: " AAA BBB CCC"

There is 4 space between AAA & BBB, but we need only one space between AAA & BBB. How to remove this extra space?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2010
Added on May 9 2010
#pl-sql, #sql
9 comments
172,905 views