Skip to Main Content

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!

Removing invalid spaces from a string

2749272Sep 10 2014 — edited Sep 10 2014

Hi All,

I have a string in pl/sql which has 'New line' , 'Form Feed' , 'Carriage Return' , 'Horizontal / vertical Tab space'  and many white space characters.

For eg:

variable1 varchar2(3000);


variable1 = 'Hello world                   hello world
Hello world              Hello world                                      Hello world
Hello world'

I require a query to remove all the spaces(specially it should remove \f,\t,\n,\v,\r) and the string should be looks as below

var 1 = ' Hello world Hello world Hello world Hello world Hello world Hello world '

Please help. Thanks in advance.

This post has been answered by chris227 on Sep 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2014
Added on Sep 10 2014
2 comments
1,226 views