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 trailing carriage returns

frm40735Apr 8 2013 — edited Apr 8 2013
I have this field that has chr(10) for each line at the end, however there are 2 CHR(10) at the end
I've tried replace but that didn't work also reading you can't use regexpr_replace with a negative value.


e.g.

This is line1 chr(10)
This is line 2 chr(10)
chr(10)
chr(10)

Any ideas please
Database 10g Enterprise Edition Release 10.1.0.5.0
This post has been answered by jeneesh on Apr 8 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2013
Added on Apr 8 2013
4 comments
3,805 views