PLS-01424: Non-ANSI order of clauses

PLS-01424: Non-ANSI order of clauses
Cause: ANSI specifies an ordering to clauses in a table-expression which PL/SQL doesn't. The ordering according to ANSI must be: (1) from clause (2) where clause (3) group-by clause (4) 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: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:03

PLS-01424：非ANSI的子句顺序,
.原因： ANSI指定PL / SQL中没有的表表达式中的子句的排序。根据ANSI的排序必须是：（1）from子句（3）where子句（3）group-by子句（4）具有子句在PL / SQL中，from子句必须先到，之后的子句可以出现在任何订单（添加非ansi连接条款）。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

PLS-01424: Non-ANSI order of clauses

1 个回答

相似问题