"ORA-937: not a single-group group function" from Query With Window Function in Views Select List Not Referenced by Parent Query Block
(Doc ID 1485906.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Server - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- Query contains a Window function (for example: first_value("T0"."C3") over(partition by "T0"."C0") ) in the select list that is NOT referenced in the parent query. By way of an abstract example below, the "Window_Function" column from the view VW is not referenced in the outer query:
Upgrade to 11.2
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document