Re: sqlldr and flat file
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 15 Aug 2009 12:21:40 +0200
Message-ID: <4a868c34$0$2853$ba620e4c_at_news.skynet.be>
hehehe schreef:
> Hello!
>
> I need to import with sqlldr data from flat file, but row is termionated
> by ENTER
>
> this is sample of my data file:
>
> John
> Smitch
> 1988
> Class
> 8
> -------------------
> Martin
> Jezrob
> 1982
> Class
> 0
> -------------------
> etc......
>
>
> how create control file for sqlldr to import that data?
>
> Regards - MJ
>
>
Date: Sat, 15 Aug 2009 12:21:40 +0200
Message-ID: <4a868c34$0$2853$ba620e4c_at_news.skynet.be>
hehehe schreef:
> Hello!
>
> I need to import with sqlldr data from flat file, but row is termionated
> by ENTER
>
> this is sample of my data file:
>
> John
> Smitch
> 1988
> Class
> 8
> -------------------
> Martin
> Jezrob
> 1982
> Class
> 0
> -------------------
> etc......
>
>
> how create control file for sqlldr to import that data?
>
> Regards - MJ
>
>
Hi!
RTFM! GHP PS. concentrate on "concatenate" and "continueif" http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_load_multi-line_records.3F Received on Sat Aug 15 2009 - 05:21:40 CDT