Removing line breaks from a query
886466Sep 6 2011 — edited Sep 6 2011Hello 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.