Does anyone have an example of using SQL*Loader to load data with newlines embedded in them?
Ideally, I'd like to have a loader script that loads data akin to this:
#ROWID, NAME, DATA
1,"this data","blah blah blah"
2,"newline data", "This data has newlines...
There are several columns in my database which or of type LONG RAW or BLOB. I would like a simple way to view the data within these columns, but Oracle seems to stimey me at every turn. There are plenty of ways to get data *into* these fields, but no real good ways of getting out such that I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.