Re: Oracle External Table / DAT file data problem
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Thu, 30 Jan 2014 15:31:47 +0000
Message-ID: <CAOuMUT4vXRNgch1GUfMjhwkkPzkAvSOS5YKc=QX=gFy+D8GcFg_at_mail.gmail.com>
Hi Chris,
Date: Thu, 30 Jan 2014 15:31:47 +0000
Message-ID: <CAOuMUT4vXRNgch1GUfMjhwkkPzkAvSOS5YKc=QX=gFy+D8GcFg_at_mail.gmail.com>
Hi Chris,
This is taken from an 11g sqlloader control file. Haven't tried this with an external table but I think it should work:
APPLICATION_DATE POSITION (203:210) DATE(8) "YYYYMMDD" nullif application_date = '00000000'
Regards,
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 30 2014 - 16:31:47 CET