Re: analytics reference
Date: Tue, 12 Aug 2014 10:51:55 -0500
Message-ID: <CAO9=aUzFhQ85PRnyF8qdc=fru_WLhmx9Bg=HMAJ_JhFdv3iNPQ_at_mail.gmail.com>
Chris, I read about the MODEL statement in the docs a good year or so ago and it sounded pretty amazing to me. It seemed like MODEL essentially lets you create something very similar to a spreadsheet directly from SQL. Is that what you found it to be like as well?
On Tue, Aug 12, 2014 at 10:46 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> I had to use a combination of resources together. I the Oracle Data
> Warehousing documentation (believe it or not) helped me a ton - reading the
> documentation (in order of each function) and then looking at examples from
> different blogs to see the query in action (and various forms it could
> take).
>
> Then I took some of the most useful functions and started writing them
> against database tables where I wanted some details - so I could get used
> to using them:
>
> Links:
> http://docs.oracle.com/cd/E11882_01/server.112/e25554/analysis.htm#DWHSG021
>
> Helpful usage examples:
>
> http://www.oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions.php
> http://www.orafaq.com/node/55
>
> http://www.oracle.com/technetwork/issue-archive/2013/13-mar/o23sql-1906475.html
>
> Book that was really helpful (but was (IMHO) a rehash of the Oracle
> documentation on the matter in better form):
> http://www.rampant-books.com/book_0802_advanced_sql_programming.htm by
> Laurent Schneider
>
> Also Laurent Schneider has several posts scattered around the web with
> some good examples.
>
> Best of luck!
>
> Chris
>
> P.S. When you finally write a MODEL statement and understand it and can
> manipulate it, it's AWESOME. (I've only done it a handful of times and
> would have to refresh my own use of it because I never see it in use by
> anyone besides me)
>
>
>
> On Tue, Aug 12, 2014 at 10:09 AM, Adric Norris <landstander668_at_gmail.com>
> wrote:
>
>> Can anyone recommend a good reference (preferably with lots of examples)
>> on the use of Oracle analytic functions? It tends to be something of a
>> struggle whenever I use the beasties, and I'd like to get my head wrapped
>> around them a bit better.
>>
>> Thanx!
>>
>> --
>> "In the beginning the Universe was created. This made a lot of people
>> very angry and has been widely regarded as a bad move." -Douglas Adams
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 12 2014 - 17:51:55 CEST