Analytical functions

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
izaiascatelli
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 16
Joined: Tue, 17 May 2005 4:24 pm
Location: curitiba pr

I need material ( in Portuguese ) on analytical functions, those that use syntax:

Select all

Analytic-Function(<Argument>,<Argument>,...) 
OVER ( 
  <Query-Partition-Clause> 
  <Order-By-Clause> 
  <Windowing-Clause> 
)
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

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

I'm also looking for this material in Portuguese.
But for now, this link below is breaking me the biggest branch.
http://en.glufke.net/oracle/download/fu ... TICAS.html

It has examples of some types of analytical functions. In the SQL manual also has good examples of all necessary functions. (Unfortunately, they are also in English)

: -O


Posted this link: http://en.glufke.net/oracle/viewtopic.php?t=3169
Last edited by dr_gori on Tue, 15 Dec 2009 12:05 pm, edited 2 times in total.
User avatar
leobbg
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 22
Joined: Fri, 29 Oct 2004 10:25 am
Location: PORTO ALEGRE - RS
Leo BBG Consultor Oracle

What would you be needing IzaiAscatelli ??

Something in particular? Anything, hold the scream !!

: Twisted:
emorelli
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Tue, 15 Dec 2009 9:50 am
Location: Rio de Janeiro - RJ
Contact:

New Book: Oracle DBA Essential Volume I (in Portuguese!) Has a whole chapter on analytical functions (Chapter 12). There are syntaxes and several examples www.eduardomorelli.com)
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

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

Edited link above: (it was broken).
Upload the HTML document to: http://en.glufke.net/oracle/download/fu ... TICAS.html

: -O
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 14 guests