Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlldr & Date/time
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
![]() |
![]() |