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 line breaks from a query

886466Sep 6 2011 — edited Sep 6 2011
Hello everyone,

I am trying to write a query using Oracle SQL Developer and one of the fields contains notes. Unfortunately there are many line breaks caused by when a user presses the enter key as they are typing notes into our system. The line breaks can only be seen when we export the data into excel to produce performance monitoring spreadsheets.

Would it be possible to remove the line breaks (perhaps substituting them with a space) without updating the data in the database?

I am sorry if I should not have created a new thread but I cannot find the answer anywhere.
This post has been answered by lee200 on Sep 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2011
Added on Sep 6 2011
9 comments
21,067 views