-5

In which version of Oracle is over clause is present? What is the purpose of this clause?

peterh
  • 11,875
  • 18
  • 85
  • 108
Shyam
  • 9
  • Window functions (aka "analytical functions") were introduced in Oracle 8.1: http://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/function.htm#81409 –  Sep 07 '15 at 07:31
  • It should have been made duplicate. I have mentioned the original question in the below answer. – Biswabid Sep 07 '15 at 07:33
  • @Biswabid: the question you linked to asks _what_ that is. Shyam is asking in which version they are available. –  Sep 07 '15 at 07:34
  • @a_horse_with_no_name : It asks the Purpose of this clause also, thats why i suggested the below answer.(which is the original question) – Biswabid Sep 07 '15 at 07:36

1 Answers1

2

The OVER clause specifies the partitioning, ordering & window "over which" the analytic function operates
Reference: OVER clause in Oracle

Community
  • 1
  • 1
Biswabid
  • 1,378
  • 11
  • 26
  • Thanks @Biswabid. Thereby, the OVER clause defines a window or user-defined and specified set of rows within a query result set. A window function then computes a value for each row in the window. We can use the OVER clause with functions to compute aggregated values. – Shyam Sep 08 '15 at 11:36