Re: Oracle External Table / DAT file data problem

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 30 Jan 2014 09:48:38 -0600
Message-ID: <CAP79kiRxZit_AEyS0kBcsALN2TPjnAfmxF4feWB-VUv2=vw4CA_at_mail.gmail.com>



Yep - trying to determine if I can create multiple nullif checks on one column...

Chris

On Thu, Jan 30, 2014 at 9:43 AM, Kim Berg Hansen <kibeha_at_gmail.com> wrote:

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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 30 2014 - 16:48:38 CET

Original text of this message