Jared,
Since you and Jon had already met Srinivas's needs with the examples you two
provided, I didn't see much sense in throwing in my two cents except that
since Srinivas was *so* close with his approach, I thought it would be
helpful to show the key piece he was missing. And I would bet the ranch that
you and Jon have used the same technique multiple times in the past as well.
Considering there is no performance difference with all 3 returning results
instantaneously, I might lean towards your approach -- the clarity and
purpose of the code is more obvious. Some folks get a glazed look in their
eyes when they see aggregate/decodes and or in-line views, and that always
needs to be taken into account.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jared Still
> Sent: Sunday, August 05, 2001 5:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: divide with decode
>
>
>
> Now why didn't I think of that? :)
>
> Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Elkins
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
