Re: sqlldr & Date/time

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 15 Mar 2002 13:36:05 +0100
Message-ID: <3C91EAB5.BEAF8E1D@mytoys.de>

> It may not always be possible or permissible. (yes the later is a
> political issue, but it happens.) What if the order of the fields were
> date, vmstat, time
> removing one comma wouldn't help.

ACK.
> So the question remains: Is it possible in SQLLDR, using terminated
> fields (instead of fixed length) to refer to a field of the input file
> that is not directly being loaded to a column in the destination
> table? (Why must the fields exists one-to-one with column names?)

Did you read the documentation about FILLER? I didn't have the time to test it but it's worth a try.

Regards,

Knut Received on Fri Mar 15 2002 - 06:36:05 CST