Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Cartesian product with totals
> 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
![]() |
![]() |