ORA-30487: ORDER BY not allowed here

Question Posted / guest

ORA-30487: ORDER BY not allowed here..

Answer / guest

Cause: DISTINCT functions and RATIO_TO_REPORT cannot have an
ORDER BY

Action: none

Please add more information about this Error

Is This Answer Correct ?

1 Yes

0 No

More Oracle Errors Interview Questions

ORA-08191: Flashback Table operation is not supported on remote tables

EXP-00072: error closing export file string

ORA-22326: cannot change a type to FINAL if it has subtypes

ORA-09218: sfrfs: failed to refresh file size

ORA-01179: file string does not exist

PCB-00632: Cannot open an External LOB in READ WRITE mode

ORA-32321: REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE

ORA-14623: Value string does not exist in subpartition string

RMAN-06601: new RMAN configuration parameters:

ORA-31215: DBMS_LDAP: PL/SQL - Invalid LDAP mod value.

IMG-00843: internal image structure allocation failed

RMAN-06167: already connected

For more Oracle Errors Interview Questions Click Here