Re: Need sql*loader help

From: Roger Stapley <rstapley_at_uk.oracle.com>
Date: 17 Dec 1998 14:51:52 GMT
Message-ID: <75b5q8$95l$1_at_inet16.us.oracle.com>


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 Thu Dec 17 1998 - 15:51:52 CET

Original text of this message