Re: sqlloader qq (Also, concat two cols?)

I have been looking for this everywhere too...for now I'm using awk to hack my text file, but I'd rather be able to do it with SQL*Loader directly.

Also, I need to insert a date column. The 'date' and 'time' fields in my data file are separate. Is possible to get them together to form an appropriate date?

Thanks.

Cosmin Ioan wrote:

> hello all,
>
> I was wondering if it is possible to load the n-th field in a variable
> length (tab delimited) file.
>
> Ex. I have a large txt file with about 100 fields (tab delimited) and I
> need to import just a few columns. Is it possible? If so, could someone
> help me w/ the syntax?
>
> Thanks,
>
> Cosmin
Received on Tue Sep 28 1999 - 17:59:58 CEST