Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control File: TAB (ascii 9)
Cool!
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Tim Romano wrote in message <3558F206.20C78B0B_at_superstream.net>...
>Finally found it in the Complete Reference (had been looking
>in the DBA Handbook):
>
>FIELDS TERMINATED BY X'9'
>
>
>
>Tim Romano wrote:
>>
>> Thanks for the reasonable suggestion, Terry, but sqlldr73 is
>> being unreasonable: Error 350, syntax error, 'Expecting
>> quoted string. found "CHR" '
>> Tim
>>
>> Terry Dykstra [TeamPS] wrote:
>> >
>> > Try using FIELDS TERMINATED BY CHR(9)
>> >
>> > --
>> > Terry Dykstra [TeamPS]
>> > Canadian Forest Oil Ltd.
>> > Tim Romano wrote in message <355872F8.2EC8B2F9_at_superstream.net>...
>> > >How do you specify in the control file that columns in the
>> > >incoming text file are TAB-delimited [ascii 9]?
>> > >
>> > >FIELDS TERMINATED BY _____
>> > >
>> > >TIA
>> > >Tim
Received on Thu May 14 1998 - 18:21:41 CDT
![]() |
![]() |