Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL-Loader-Problem
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