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!

Replace carriage return or new line with space in table

815519Oct 9 2013 — edited Oct 9 2013

Hi

i want to replace carriage return or new line with space in my one of the column of the database.

For this , i am using this query :

select replace(replace(Comments,chr(10),' '),chr(13),' ') FROM Comments_Master

Comments_Master is table name and Comments is column on which contains carriage return or new line.

But this query is not working as expected.

Once i run this query and again execute the query " select * FROM Comments_Master " , carriage return and new line still exist.

Please let me know what is problem with this query ?
This post has been answered by adi999 on Oct 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Oct 9 2013
7 comments
18,092 views