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

ERRORA SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause
CAUSEA SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause. Sect. 8.10.
ACTIONNone