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 -> substitute null values in SQL query?

substitute null values in SQL query?

From: <wykoff_at_my-deja.com>
Date: Wed, 30 Jun 1999 00:05:59 GMT
Message-ID: <7lbn11$vge$1@nnrp1.deja.com> 





Hi,



Once again I need equivalent SQL behavior to an SQL Server query in
ORACLE.


The value in the select is the difference in dates unless the difference
returns NULL.  In this case it returns 0 (via IsNULL()).  I'm looking
through the SQL Language reference, but I'm not coming up with anything.



Thanks for your help,



kim




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 19:05:59 CDT












Original text of this message













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