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!

Word Wrap in export

ChristianApr 2 2013 — edited Apr 4 2013
Hey, I am still working on my export script.

I export data with the spool option into a csv file.

One problem left.
I have one column, where the operator inserted an explicit wordwrap. So opening the file in notepad or in excel I do an wordwrap. Is there a way of deleting this empty row ?

So the text in the sql select statement looks like:

sql> select columnname from table;

ColumnName
------------------------------------------------------------------------------------------
Word one two three

word four five six seven

Christian
This post has been answered by John Spencer on Apr 2 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2013
Added on Apr 2 2013
6 comments
805 views