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!

write a custom oracle function to remove chr(10)=linefeed & chr(13)=carriage return and trim column

user649990Dec 4 2016 — edited Dec 5 2016

Is it possible to write a custom oracle function that does the following

remove char(10) remove char(13) trim

so if i write

select custom_function(col1) from tab1 it returns value with linefeed,carriage return and trimmed

If possible i also want to replace a long balnk line between two words with single blank.

where col1 is string

Can someone please help me in this

Thanks a lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2017
Added on Dec 4 2016
3 comments
3,467 views