Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Control File: TAB (ascii 9)
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 Tue May 12 1998 - 20:06:14 CDT