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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Additional new line break when a record has a field which contains new line characters

7aef9d69-ffb0-4235-b91f-b9df7bddff92Dec 16 2015 — edited Dec 16 2015

Hi,

I'm having issues spooling a file without empty lines. I noticed the problem is SQLPLUS is returning additional line breaks right after returning a record which has new line characters in it. See screenshot below:

sqlplus_newline.png

Notice that there's an extra line break after the record which says "multiple line1 & multiple line2".

Is there an SQLPLUS settings which I can use to get rid of the extra line? If not, what are the other option which I can use to get rid of it.

I can't really use sed on unix because there could be a field which contains empty line.

Also note that I need the data to remains the same, in other words, I need to retain the new line characters within the column

Please advise.

Thanks in advance
This post has been answered by Karthick2003 on Dec 16 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2016
Added on Dec 16 2015
#sqlplus
4 comments
1,399 views