PLS-01424: Non-ANSI order of clauses



PLS-01424: Non-ANSI order of clauses..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01085: materialized view, string, has a lossy join between tables, string

1 Answers  


ORA-30358: summary and materialized view are not in same schema

1 Answers  


ORA-27022: skgfqsbi: could not allocate memory for media manager

1 Answers  


ORA-16209: Logical standby dictionary build failed to complete.

1 Answers  


ORA-19574: output filename must be specified

1 Answers  






DRG-10205: server deregister failed

1 Answers  


AMD-00132: dimension #string: RDBMS GID column data type not specified

1 Answers  


ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'

1 Answers  


NNO-00117: line string: missing data type, data ignored

1 Answers  


ORA-28658: This operation is supported only for Index-Organized tables

1 Answers  


ORA-01974: Illegal archive option

1 Answers  


SQL-02147: ANSI Dynamic occurrence value out of range

1 Answers  


Categories