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: SQLLOADER Q?

RE: SQLLOADER Q?

From: Cotham, Pam <pam.cotham_at_eds.com>
Date: Thu, 13 Jul 2000 18:58:46 -0500
Message-Id: <10557.112008@fatcity.com>


You could set the column to default value 0 during the load.

Pamela A. Cotham
Senior System Engineer/Oracle DBA
EDS CA-XIX Senior Consultant
916.636.1964
pamcotham_at_eds.com

> -----Original Message-----
> From: Jack Silvey [SMTP:JSilvey_at_XOL.com]
> Sent: Thursday, July 13, 2000 4:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQLLOADER Q?
>
> you can use functions in the SQL*loader control file. This feature is not
> well documented, but try the NVL() funtion. I think that is the way that I
> did it.
>
> Jack
> ocp x 2
> senior @ xol.com
>
> -----Original Message-----
> Sent: Thursday, July 13, 2000 9:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
>
> Hi All,
>
>
> went through the doc's but no answer yet (looks like not posible)
>
> I want to load a file that has "null" values. During the load I want to
> substitute all null values with the number "0" (=zero)
> Anybody tried this before?
>
>
>
> Jack
>
>
> ===================================================================
> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
> de geadresseerde. Gebruik van deze informatie door anderen dan de
> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
> en/of verstrekking van deze informatie aan derden is niet toegestaan.
> Ernst & Young staat niet in voor de juiste en volledige overbrenging van
> de
> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ===================================================================
> The information contained in this communication is confidential and may be
> legally privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed and others authorised to receive it. If you
> are not the intended recipient you are hereby notified that any
> disclosure,
> copying, distribution or taking any action in reliance on the contents of
> this information is strictly prohibited and may be unlawful. Ernst &
> Young is neither liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt.
> ===================================================================
>
>
>
> --
> Author: Jack van Zanen
> INET: nlzanen1_at_ey.nl
>
> 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).
> --
> Author: Jack Silvey
> INET: JSilvey_at_XOL.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
Received on Thu Jul 13 2000 - 18:58:46 CDT

Original text of this message

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