Oracle Error QSM-01213: query rewrite not possible when nested aggregates or CONNECT BY clause or START WITH clause or recursive WITH clause is present

Oracle Error Message

QSM-01213: query rewrite not possible when nested aggregates or CONNECT BY clause or START WITH clause or recursive WITH clause is present

Reason for the Error

If the query contains nested aggregates, CONNECT BY clause, or START WITH clause, or recursive with clause, query rewrite will not take place

Solution

None