Re: Problem loading text data into Oracle8

From: <hillt_at_doimex1.sill.army.mil>
Date: Thu, 31 Dec 1998 17:29:25 GMT
Message-ID: <76gc9j$16r$1_at_nnrp1.dejanews.com>


Thanks!! That worked perfectly. Now if I could only repair the entries like '199104' (:-) (Obviously no validation was done when the original data was entered.)

In article <01be3499$a9e74820$190114c1_at_sister.grant.UUCP>,   "Alexander I. Doroshko" <aid_at_grant.kharkov.ua> wrote:
> Try
>
> ETS_DATE POSITION(xx:yy) DATE "YYMMDD" NULLIF (ETS_DATE=BLANKS) "decode(
> :ets_date, '000000', null, :ets_date)"
> ---
> Alexander I.Doroshko, aid_at_grant.kharkov.ua
> * Bank "Grant", Kharkov, Ukraine
>
> hillt_at_doimex1.sill.army.mil wrote in article
> <76b84c$2kd$1_at_nnrp1.dejanews.com>...
> > I have a 581MB text file, fixed length records (VSAM files from IBM MF)
> that
> > contains several date fields as YYMMDD that may be either blanks or
> '000000'.
> > How can I use the SQL*Loader to load these records?
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 31 1998 - 18:29:25 CET

Original text of this message