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: Oracle equivalent to DB2 NULLIF function?

Re: Oracle equivalent to DB2 NULLIF function?

From: <michael_bialik_at_my-deja.com>
Date: Fri, 16 Jul 1999 18:04:33 GMT
Message-ID: <7mns77$mg5$1@nnrp1.deja.com>


You are right, but using DECODE in SQL*Loader prevents you from using it in DIRECT mode.

  Regards. Michael.

In article <7mnevq$mbs$1_at_news.btv.ibm.com>,   "Jim Morgan" <jjmorgan_at_us.ibm.com> wrote:
> Interesting that NULLIF exists only in SQL*LOADER...I wonder why? But
> decode is actually more powerful since you can get any value returned
based
> on how an expression evaluates, not just NULL.
>
> --
> Regards,
> Jim
> <michael_bialik_at_my-deja.com> wrote in message
> news:7mnclo$fek$1_at_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.
>
>

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

Original text of this message

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