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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL-Loader-Problem

Re: SQL-Loader-Problem

From: Lothar Armbruester <lothar.armbruester_at_rheingau.netsurf.de>
Date: 1998/01/26
Message-ID: <856.330T5T13042172@rheingau.netsurf.de>#1/1

On 26-Jan-98 12:22:16 H. Fellinghauer wrote:

>christian.guenther_at_mch.sbs.de wrote:
>>
>> Hello,
>> is there a possibility to say Sql-Loader to change a value, that is in
>> the INFILE a NULL-Value to another value, for example to a space??
>> I read the manual, but didn't find anything.
>You can change the value with a function like NVL(), for example:
> job integer "nvl(:job,0)"
>For more information refer to ULCASE7.CTL in your RDBMSxx/loader

It should be mentioned that you cannot use SQL functions in direct path loads. Perhaps it is worth trying default values on columns which would be set to null. I don't know if that works but I think it has good chances! ;-)

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |
Received on Mon Jan 26 1998 - 00:00:00 CST

Original text of this message

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