Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sqlldr / new line?

sqlldr / new line?

From: Tino Korth <korthNOSPAM_at_mhr.de>
Date: Fri, 21 Feb 2003 10:23:14 +0100
Message-ID: <b34r63$q9v$1@ngspool-d02.news.aol.com> 





hello,



i'm using sqlldr to put a data (text) file into an oracle db.
sqlldr has got problems with "new lines" in text-fields.
how does i have to quote "new line"'s?



the "problem dataset":



6,"2002-08-15 10:46:41","Test","Line1\nLine2\nLine3",0




thanks!



greetz from rostock, germany!



tino
Received on Fri Feb 21 2003 - 03:23:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US