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

Home -> Community -> Usenet -> comp.databases.oracle -> Setting Null values to Zero

Setting Null values to Zero

From: C. Lo <starshipdb_at_hotmail.com>
Date: 6 Mar 2004 10:26:01 -0800
Message-ID: <713a6263.0403061026.3dfed2bb@posting.google.com>

Hi

I have a situtation where a query returns a table in which some of the values are null. When I sort the results, the null values are treated as greater than the other numerical results. Is it possible to set the database treat the null values as zero?

Thanks Received on Sat Mar 06 2004 - 12:26:01 CST

Original text of this message

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