Skip to Main Content

ODP.NET

SUM, AVG, and other aggregate function

User_SS7U9Aug 1 2022

The 21c documentation here
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Aggregate-Functions.html#GUID-62BE676B-AF18-4E63-BD14-25206FEA0848
says
......In the listing of aggregate functions at the end of this section, the functions that allow the windowing_clause are followed by an asterisk (*).......
But when I see the SUM, AVG, and many other functions, they are not followed by *, whereas they do allow windowing clause.
Moreover CORR allows windowing but not followed by *
Moreover CORR_ dosnt allow window clause but it is followed by *, later on I realized that in case of CORR_* star denotes K or S.
So is there any documentation bug?
Is there any documentation ambiguity in case of CORR_*.?

Comments
Post Details
Added on Aug 1 2022
2 comments
43 views