Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help with join

Re: help with join

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Wed, 28 Jul 2004 20:14:03 GMT
Message-ID: <fOTNc.114309$Rf.6656@edtnps84> 





Root wrote:


<snip>


> nvl takes two arguments, returns the first if they are not equal?

> 



no, it can expressed like this:



If the first value listed IS NULL, then use the second listed value.



NULL does not evaluate to anyting, it's unknown, so cannot be EQUAL to 
anything.



The oracle docs are at tahiti.oracle.com
Received on Wed Jul 28 2004 - 15:14:03 CDT












Original text of this message













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