Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader defaultif?

RE: SQL*Loader defaultif?

From: Steven Monaghan <Steve.Monaghan_at_wcom.com>
Date: Mon, 31 Jul 2000 10:51:16 -0400
Message-Id: <10575.113368@fatcity.com>


You can use
field_name "nvl(:field_name, 'ABC')",

That should do it.

Steve Monaghan

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Martin,
> Alan
> Sent: Monday, July 31, 2000 9:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL*Loader defaultif?
>
>
> I've read the manuals and still need help with:
>
> How do I specify, "If the data in the flat file to be loaded for
> column XXX
> is NULL, default the column to 'ABC' "? I tried using CONSTANT 'ABC', but
> that doesn't read (skips) any data from the flat file for that
> column, which
> brings up another question. Is there a way to skip (dummy-up) the
> reading of
> a column of data? Is DEFAULTIF what I need? Please show an example.
>
> Thanks,
> Alan Martin
> Database Administrator
> GMAC Insurance Personal Lines
> Winston-Salem, NC
> Alan.Martin_at_GMACInsurance.com
>
>
>
> ------------------------------------------------------------------
> ------------------------------------------------------------------
> --------------
> Note: The information contained in this message may be
> priviledged and confidential
> and protected from disclosure. If the reader of this message is
> not the intended recipient,
> or an employee or agent responsible for delivering this message
> to the intended recipient,
> you are hereby notified that any dissemination, distribution or
> copying of this communication
> is strictly prohibited. If you have received this communication
> in error, please notify us
> immediately by replying to the message and deleting it from your
> computer. Thank you.
> ------------------------------------------------------------------
> ------------------------------------------------------------------
> --------------
>
> --
> Author: Martin, Alan
> INET: Alan.Martin_at_GMACInsurance.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jul 31 2000 - 09:51:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US