I have a table that contains html formatted text in Oracle. I'm trying to export that to a csv but can't use the built in SQL Developer Export features because of character limits.

I've tried almost every combo of the examples on this site using SQL Plus but the HTML keeps getting either truncated, split across rows based on line breaks in the data and regardless of SET COLSEP '|' it's deliminated by a comma.

Anyone have any thoughts on how to get each data cell into one csv cell?

  • If the data can contain chr(10) then CSV format is the wrong choice. I reccomend XML. – Michael Kutz Mar 20 at 23:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.