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!

regexp_replace to remove new line and or tab characters

733774Mar 1 2010 — edited Mar 1 2010
I have a character feild that has tab delimited characters as well as new line characters in it.

How do i remove those characters from the string? I just need everything without these.

I have to have regexp_replace but dont know how.

the field is description

select description from table1.


Thanks
billu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2010
Added on Mar 1 2010
2 comments
20,083 views