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 -> Oracle8i and nullif

Oracle8i and nullif

From: Ralph <nurfuerschrott_at_gmx.de>
Date: 5 Oct 2005 07:30:31 -0700
Message-ID: <1128522631.634681.321940@g43g2000cwa.googlegroups.com>


Hi @ll,

is there anything like the nullif-function in oracle8i ? It can be a more complex construction, the only need is, that it can be used in the fieldlist.

select
number,nvl2(nullif(to_char(birthday,'YYYY'),to_char(welcomedat,'YYYY')),'Yes','No') from customer

This works fine in 9i (not regarding the senseless columns) but I can't find anything similar in 8i...

Any ideas?

Greets Ralph Received on Wed Oct 05 2005 - 09:30:31 CDT

Original text of this message

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