Analytic functions

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Wed, 25 Jan 2006 1:22 pm

I need material ( in Portuguese ) about analytic functions, those that use the syntax: Analytic-Function (<Argument>,<Argument>, ...)
OVER (<Query-Partition-Clause> <Order-By-Clause> <Windowing-Clause>)
izaiascatelli
Location: curitiba pr

Poston Wed, 25 Jan 2006 3:23 pm

I am also looking for this material in Portuguese.
But for now, this link below is me breaking the biggest branch.

download/funcoes_ANALITICAS.html as it has examples of some types of analytical functions. In Handbook of SQL also has good examples of all necessary functions. (unfortunately, they are also in English):-posted this link: viewtopic.php?t=3169
Last edited by dr_gori on Tue, 15 Dec 2009 12:05 pm, edited 2 times in total.
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Mon, 06 Feb 2006 2:02 pm

Than you would be needing izaiascatelli??

Anything in particular? Anything, holds the cry!!

: twisted:
leobbg
Location: PORTO ALEGRE - RS

Leo BBG Consultor Oracle

Poston Tue, 15 Dec 2009 9:54 am

New book: Oracle DBA Essential Volume I (in Portuguese!) has a whole chapter about analytic functions (section 12). There are several examples and syntax (http://www.eduardomorelli.com)
emorelli
Location: Rio de Janeiro - RJ

Poston Tue, 15 Dec 2009 12:05 pm

Edited the above LINK: (was broken).
Done uploading the html document to: download/funcoes_ANALITICAS.html:-
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: No registered users and 4 guests