Re: Analytic SQL Book?

From: chet justice <chet.justice_at_gmail.com>
Date: Tue, 29 Sep 2009 16:27:49 -0400
Message-ID: <8311a5b60909291327m7b53e8adw2d15b1b08dc48ecc_at_mail.gmail.com>

The best in terms of documentation is the Data Warehouse Guide: http://download.oracle.com/docs/cd/B28359_01/server.111/b28313/analysis.htm#i1007779

Other than that, a little practice on small sets of data will do you quite a bit of good. Also, if you think of analytics as a GROUP BY within a subset of your result set, it helps out a bit. The PARTITION BY is effecctively a GROUP BY clause.

Playing around with it, especially ROW_NUMBER and RANK with small sets will do far more than any book can give you...in my opinion anyway.

chet

On Tue, Sep 29, 2009 at 4:09 PM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> Does anyone have any recommendations for a good/detailed Oracle analytic
> SQL book (analytic functions from the "ground up")?
>
> Thanks,
>
> *Chris Taylor*
> *Sr. Oracle DBA*
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor_at_ingrambarge.com
>
>
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 29 2009 - 15:27:49 CDT