(no subject)

From: Narender Akula <Narender.Akula_at_telecom.co.nz>
Date: Fri, 14 Jul 2000 14:03:42 +1200
Message-Id: <10557.112013@fatcity.com>

you can use either nvl or constant both will work if the in field is = null.

col1 CONSTANT 0
or=20
col2 "nvl(:col2,0)"

make sure that it is conventional path load

naren

>>> pam.cotham_at_eds.com 14/July/2000 01:05pm >>>
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?
>=20
> 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.
>=20
> Jack
> ocp x 2
> senior @ xol.com
>=20
> -----Original Message-----
> Sent: Thursday, July 13, 2000 9:56 AM
> To: Multiple recipients of list ORACLE-L
>=20
>=20
>=20
>=20
>=20
> Hi All,
>=20
>=20
> went through the doc's but no answer yet (looks like not posible)
>=20
> I want to load a file that has "null" values. During the load I want to
> substitute all null values with the number "0" (=3Dzero)
> Anybody tried this before?
>=20
>=20
>=20
> Jack
>=20
>=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> 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, verspreidin=
g
> 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.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> 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.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
>=20
>=20
> --=20
> Author: Jack van Zanen
> INET: nlzanen1_at_ey.nl
>=20
> 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).
> --=20
> Author: Jack Silvey
> INET: JSilvey_at_XOL.com
>=20
> 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).
--=20
Author: Cotham, Pam
INET: pam.cotham_at_eds.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).

=20

Received on Thu Jul 13 2000 - 21:03:42 CDT