Database Administration (MOSC)

MOSC Banner

Displaying newlines from an oracle table

edited Dec 12, 2019 7:20AM in Database Administration (MOSC) 7 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center