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

TNS-04012: Unable to start Oracle Connection Manager instance.

ORA-29892: indextypes with array DML do not support the given data type

NNL-00904: NAME EXISTS responses sent: number

ORA-19624: operation failed, retry possible

NNL-00010: error getting address for server "string"

PLS-00566: type name "string" cannot be constrained

ORA-07208: sfwfb: failed to flush dirty buffers to disk.

ORA-16750: Resource guard encountered errors while activating logical primary

ORA-31460: logfile location string is not an existing directory

LFI-00007: NLSRTL's call failed. string.

DRG-50100: CORE LSF error: string

ORA-24274: no row exists in the string table for these parameters

For more Oracle Errors Interview Questions Click Here