On Mar 9, 10:13 pm, DA Morgan <damor..._at_psoug.org> wrote:
> > Sorry Daniel,
> > My attempts to incorporate the COALESCE function failed,
> > therefore I omitted that from the code to eliminate confusion. I'm
> > using Oracle 9 and I simply want Null to return '0' as a blank record
> > in this case essentially means zero.
>
> NVL will do it.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Sorry I didn't follow up - To clarify what I've done...I created an
additional case statement for the case statement to eliminate the
divide by zero issue. After reading this I also used NVL to figure out
that solution, which also worked for me.
Received on Fri Mar 23 2007 - 12:49:35 CDT
