Home » SQL & PL/SQL » SQL & PL/SQL » What is Analytical function? (11g)
What is Analytical function? [message #618091] Mon, 07 July 2014 12:08 Go to next message
sachinpawar80
Messages: 5
Registered: March 2010
Location: Pune
Junior Member
Can someone please tell me about Analytical function?

Report message to a moderator

Re: What is Analytical function? [message #618093 is a reply to message #618091] Mon, 07 July 2014 12:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
welcome to this forum

But realize that we are NOT here to Read The Fine Manual to you.

http://www.oracle.com/pls/db121/search?remark=quick_search&word=+Analytical+function&partno=

Report message to a moderator

Re: What is Analytical function? [message #618096 is a reply to message #618091] Mon, 07 July 2014 12:24 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
sachinpawar80 wrote on Mon, 07 July 2014 22:38
Can someone please tell me about Analytical function?


Analytic functions . I hope the link to docs would give you a lot of information.

Report message to a moderator

Re: What is Analytical function? [message #618106 is a reply to message #618091] Tue, 08 July 2014 02:01 Go to previous messageGo to next message
John Watson
Messages: 8930
Registered: January 2010
Location: Global Village
Senior Member
sachinpawar80 wrote on Mon, 07 July 2014 18:08
Can someone please tell me about Analytical function?
The way I think of it is that the analytic functions are the opposite of what SQL is meant to be: they allow you to navigate from row to row within a set, rather than processing the set as a unit.
I wouldn't think that definition is particularly accurate, but it helped me when I first came across them.

Report message to a moderator

Re: What is Analytical function? [message #618167 is a reply to message #618106] Wed, 09 July 2014 00:02 Go to previous message
sachinpawar80
Messages: 5
Registered: March 2010
Location: Pune
Junior Member
Thanks a lot for wonderful responce..

Report message to a moderator

Previous Topic: column name and procedure parameter are same in oracle
Next Topic: comparing collections
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 07:53:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.