Displaying newlines from an oracle table
I have a table containing CLOB data, which I would like to display to an application in the following manor:
This is a line of text.
This is another line of text.
etc.
Since I have not found a way to do this, an end user was able to make the change in an existing table, but I still cannot see it through SQLDeveloper. I've also tried spooling the data to a file which is cut off at the CLOB column.
Ideally, I would like to load the data containing multiple lines using sqlldr. I've tried slugging in a 'chr(10)' where a newline should start with no luck. The value chr(10) is just loaded as character data.