Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using SQL*Loader to load text with newlines?

Status
Not open for further replies.

SuperMallen

Programmer
Feb 28, 2003
3
IN
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:

Code:
#ROWID, NAME, DATA
1,"this data","blah blah blah"
2,"newline data", "This data has newlines in it.
How very inconvenient.
Because SQL*Loader will be thinking that it's a new record."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top