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: Default 'sum' to zero when recordset is empty ?

Re: Default 'sum' to zero when recordset is empty ?

From: Gary Gapinski <glg_at_apk.net>
Date: Fri, 16 Nov 2001 06:18:09 -0500
Message-ID: <3BF4F5F1.F45D618D@apk.net>

I haven't actually tested this, but try putting the subselect in an nvl function (e.g., nvl(<subselect>,0) AS myproblemtotal). Received on Fri Nov 16 2001 - 05:18:09 CST

This message: [ Message body ]
Next message: Dmitry: "Re: SQL*Loader-510: Physical record is longer than 1M"
Previous message: Youtz: "1 row = 1 extent"
In reply to: Richard Shea: "Default 'sum' to zero when recordset is empty ?"
Next in thread: Richard Shea: "Re: Default 'sum' to zero when recordset is empty ?"
Reply: Richard Shea: "Re: Default 'sum' to zero when recordset is empty ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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