Re: Need sql*loader help
From: Steve Sherman <sherman9_at_bellatlantic.net>
Date: Thu, 17 Dec 1998 21:39:18 -0500
Message-ID: <3679C056.5B93DADA_at_bellatlantic.net>
> Could be because you say it's optionally enclosed by "
> and yet you're using ', try changing to "
> Roger Stapley
> (Stapley Consulting Ltd)
> roger.stapley_at_lineone.net
Received on Fri Dec 18 1998 - 03:39:18 CET
Date: Thu, 17 Dec 1998 21:39:18 -0500
Message-ID: <3679C056.5B93DADA_at_bellatlantic.net>
I was thinking the same thin.. Try " instead of '.
- steve
Roger Stapley wrote:
> In article <759do0$o59$1_at_ionews.ionet.net>, rrichard_at_gibson.ns.ionet.net
> says...
> > LOAD DATA
> > INFILE *
> > INTO TABLE PROJECT
> > FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
> > TRAILING NULLCOLS
> > ( projectnumber,
> > projecttask,
> > projectname
> > )
> > BEGINDATA
> >'894001000','0000','Airport project'
>
> Could be because you say it's optionally enclosed by "
> and yet you're using ', try changing to "
>
> Roger Stapley
> (Stapley Consulting Ltd)
> roger.stapley_at_lineone.net
Received on Fri Dec 18 1998 - 03:39:18 CET