PLS-01424: Non-ANSI order of clauses
Cause: ANSI specifies an ordering to clauses in a table-expression which PL/SQL does not. The ordering according to ANSI must be:
from clause
where clause
group-by clause
having clause In PL/SQL, the from clause must come first, and the clauses after it can appear in any order (with the addition of the non-ANSI connect-by clause).
Action: Refer to ANSI document ANSI X3.135-1992 for details.
Back to previous menu
https://support.oracle.com/
http://www.oracle.com/