Re: Oracle equivalent to DB2 NULLIF function?

From: <michael_bialik_at_my-deja.com>
Date: Fri, 16 Jul 1999 13:39:06 GMT
Message-ID: <7mnclo$fek$1@nnrp1.deja.com>

Hi,

There is the same NULLIF used in Oracle SQL*Loader utility. It works the same way as in DB2 :

LOAD DATA INFILE 'xxx.dat'
INSERT INTO TABLE emp (

     empno position(01:04) INTEGER NULLIF empno=BLANKS,
     ename POSITION(05:15) CHAR ...

Regards. Michael.
In article <7mm0pa$esm$1_at_news.btv.ibm.com>, "Jim Morgan" <jjmorgan_at_us.ibm.com> wrote:
> Anyone know if there is an Oracle equivalent to this DB2 function?
Thanks!
>
> --
> Regards,
> Jim
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 08:39:06 CDT