Re: Newbie, help again with sqlloader

I'm 90% certain of the syntax but how about..

Load data
infile ???
into table ???
fields terminated by '0B' ....

You can specify the delimeter as a tab by specifying the hexadecimal value of a tab in your sqlloader control file.

Mark

Jean-Philippe Martin wrote in message
<_aUN2.536$Eb4.811_at_weber.videotron.net>...
>Hi!
>(By the way, thanks to those who helped me before...)
>
>How can I load a .dat file with sqlloader that has tabs for delimiting
> fields (variable length): ? I tryed whitespaces but it does not seem to
>work.
>
>Thanks,
>Jean-Philippe Martin
>jeanph_at_geocities.com
>
>
>
>
>
>
>
>
>
Received on Tue Apr 06 1999 - 03:24:54 CDT