Home -> Usenet -> comp.databases.oracle -> SQL*Loader: Field termination

SQL*Loader: Field termination

From: Russell Smith <rsmith_at_serck-controls.co.uk>
Date: 10 Jan 2002 03:42:09 -0800
Message-ID: <f191bfd4.0201100342.c98246f_at_posting.google.com> 






Hi,


 I have been importing a bunch of csv's into oracle using the
sql*loader, and are having some problems.



basically the timestamp field when the csv was generated was set to be
a fixed length field, and therefore sometimes i get a date like this;



24-MAY-1998 00:00:10.


the . on the end is causing errors;


i need to know how to do an OPTIONALLY TERMINATED BY (i have just made
this up but this is what i need to do).



Any ideas?



Russ



p.s. unfortunatly the csv's can't be done again properly.
Received on Thu Jan 10 2002 - 12:42:09 CET












Original text of this message