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 -> Re: sqlldr & Date/time

Re: sqlldr & Date/time

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 19 Mar 2002 10:13:45 -0800
Message-ID: <e51b160.0203191013.e50d2dc@posting.google.com>


Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<3C91EAB5.BEAF8E1D_at_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

I do not see that (FILLER) in my manual. My copy is only version 7.3 8^(
Is this a new feature?

I'll have to check this out. Any more information you can provide would be helpful. This is just a nice-to-know question for me, but those usually turn into my having knowledge that others on my assignments need.

Thanks for the info.

   Ed Received on Tue Mar 19 2002 - 12:13:45 CST

Original text of this message

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