Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Control File: TAB (ascii 9)

Re: Control File: TAB (ascii 9)

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Thu, 14 May 1998 17:21:41 -0600
Message-ID: <355b7c0d.0@news.cadvision.com>


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

Original text of this message

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