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

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to user sqlldr in this case.

Re: how to user sqlldr in this case.

From: Volker Pohlers <volker.pohlers_at_gmx.net>
Date: Fri, 3 Sep 2004 09:07:13 +0200
Message-ID: <2pqj9rFo8b8bU1@uni-berlin.de>


Have you tried

load data

replace

into table mytable

fields terminated by ' ' optionally enclosed by '"' <-- please use the tab-character

trailing nullcols

(

      fname, ...

)

?

Volker Received on Fri Sep 03 2004 - 02:07:13 CDT

Original text of this message

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