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/