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: Tim Romano <tim_at_superstream.net>
Date: Tue, 12 May 1998 19:10:04 -0400
Message-ID: <3558D6CC.3F1DD330@superstream.net>


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 Tue May 12 1998 - 18:10:04 CDT

Original text of this message

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