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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Cartesian product with totals

Re: Cartesian product with totals

From: Noah <noah.spam.begone_at_rhinocerous.co.uk>
Date: Thu, 19 Jul 2001 10:22:20 +0100
Message-ID: <iFx57.23456$B5.1896505@monolith.news.easynet.net>

> take a look at the decode I provided you. It shows how to get a count of
> something when some field = some value vs when it doesn't.
>
> Reading your original query, I made some assumptions -- that it was keyed
 off of
> batch=4929, just use the rejection reason instead of batch in the decode
 to get
> what you want.

I see! Yes, that's excellent - thanks very much indeed. Received on Thu Jul 19 2001 - 04:22:20 CDT

Original text of this message

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