Re: Problem loading text data into Oracle8
From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 31 Dec 1998 08:44:24 GMT
Message-ID: <01be3499$a9e74820$190114c1_at_sister.grant.UUCP>
Date: 31 Dec 1998 08:44:24 GMT
Message-ID: <01be3499$a9e74820$190114c1_at_sister.grant.UUCP>
Try
[Quoted] 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>...Received on Thu Dec 31 1998 - 09:44:24 CET
> 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?