Re: SQLLOADER NULLIF OR?

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 23 Dec 1998 09:21:09 GMT
Message-ID: <01be2e55$c1d7dd40$190114c1@sister.grant.UUCP>

It seems SQL*Loader doesn't support the format required, but try

column_name NULLIF (column_name=BLANKS) "decode(:column_name, '0000', null, :column_name)"
---
Alexander I.Doroshko, aid_at_grant.kharkov.ua

Bank "Grant", Kharkov, Ukraine

Richard Murphy <rmurphy_at_lbpc.com> wrote in article <367ED2D4.43D2E518_at_lbpc.com>...
> Was wondering if multiple conditions can be applied in the control
> file. Such as:
> column_name NULLIF column_name=BLANKS OR NULLIF column_name="0000".
> Couldn't find any info in the documentation to support this.
Received on Wed Dec 23 1998 - 03:21:09 CST