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

ORA-12492: DBLOW cannot be changed

1 Answers  


ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string

1 Answers  


ORA-01543: tablespace 'string' already exists

1 Answers  


ORA-02300: invalid value for OIDGENERATORS

1 Answers  


ORA-22340: cannot string type "string"."string". Dependent tables must be upgraded to latest version

1 Answers  






RMAN-08114: channel string: restoring SPFILE to PFILE

1 Answers  


PCC-02014: Syntax error at line number, column number, file string:

1 Answers  


ORA-29307: datafile string error, string

1 Answers  


TNS-12607: TNS: Connect timeout occurred

1 Answers  


PCB-00576: PLS-number: string

1 Answers  


ORA-34360: (MXDSS15) number other users writing

1 Answers  


PCC-02348: indicators are not allowed in EXEC IAF statements

1 Answers  


Categories