Oracle8i and nullif

Giganews Newsgroups
Subject: Oracle8i and nullif
Posted by:  Ralph (nurfuerschro…@gmx.de)
Date: 5 Oct 2005

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

Replies