Re: Oracle External Table / DAT file data problem

From: Kim Berg Hansen <kibeha_at_gmail.com>
Date: Thu, 30 Jan 2014 16:43:59 +0100
Message-ID: <CA+S=qd1iutr5NQKuD4p4iHPNqm_388T3WT4LyjPcBcMurDEXOQ_at_mail.gmail.com>

True, SQLLOADER has syntax for such manipulations - WHEN, NULLIF, DEFAULTIF:

http://docs.oracle.com/cd/E16655_01/server.121/e17639/ldr_field_list.htm#SUTIL1202

And apparently external tables also have at least NULLIF (even though external tables do have less such flexibility than sqlloader):

http://docs.oracle.com/cd/E16655_01/server.121/e17639/et_params.htm#SUTIL4224

But that seems to be a 12c addition to external tables - at least I can't find it in 11.2 docs.

And OP needs a solution that works in version 9.2, alas ;-)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Thu, Jan 30, 2014 at 4:31 PM, Fergal Taheny <ftaheny_at_gmail.com> wrote:

> 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-l

Received on Thu Jan 30 2014 - 16:43:59 CET