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