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@xxxxxxxxx> 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@xxxxxxxxx > @kibeha > > > >