mrong
asked on
How to remove the line breakers in Oracle
Greeting,
I found the following function but it only removes the 1st line break.
REPLACE(col_Name, CHR(10), ' ')
Please suggest.
Thanks.
I found the following function but it only removes the 1st line break.
REPLACE(col_Name, CHR(10), ' ')
Please suggest.
Thanks.
Say more or provide an example of your input and desired output.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It will remove all the Line Feed characters.
What you likely have as a Carriage Return with a Line Feed.
Try this:
REPLACE(col_Name, CHR(13)||CHR(10), ' ')