Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlload, mission impossible ?
Hi
Try replacing 10" with 10 inches
Salman Mughal <salman_at_netdoor.com> wrote in article
<5afvuj$ja8_at_axe.netdoor.com>...
>
> It seems like an ordinary sqlload case but me and my friend spent all
night
> last night trying to figure it out and couldn't.
>
> We have been trying to load a file with lots of lines line the following
:
>
> "423567","I would not touch it with a 10" stick","35",
>
> LOAD
> INFILE 'temp.txt'
> TERMINATED BY ',' ENCLOSED BY '"'
> INTO TABLE testdb
> ( Part_Number ,
> Description ,
> Available )
>
> But keep getting the following error :
>
> No terminator found after TERMINATED and ENCLOSED field
>
> Needless to say we have tried at least a dozen other methods and none
worked.
> We cant use substr either as we dont know how long the "description"
field
> will be.
>
> I would appreciate any helpful hints. Thanks a million.
>
> Salman Mughal
> salman_at_netdoor.com
>
Received on Sun Jan 05 1997 - 00:00:00 CST
![]() |
![]() |