Oracle Error PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

Oracle Error Message

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

Reason for the Error

A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause. Sect. 8.10.

Solution

None