Re: Selecting Multiple Aggregates

From: <dili66_at_my-deja.com>
Date: Fri, 20 Oct 2000 21:23:24 GMT
Message-ID: <8sqd45$rpa$1@nnrp1.deja.com>

Hi Spenser,

Your answer was very helpful. I had started using the decode function but wasn't sure how to use it in order to form logical expressions and your suggestion showed me the way. I noticed also that oracle 8.1.6 in addition to the DECODE function provides also a CASE which could be used to select column values based on where clauses and the resulting statement is more readable compared to the case where nested DECODEs are used.

Thank you.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 16:23:24 CDT