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-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

ORA-02763: Unable to cancel at least one request

NNL-00992: Auto-refresh failure retry interval: string

ORA-28665: table and partition must have same compression attribute

DGM-16904: Unable to set attribute

PCC-02114: Command line argument MODE=ANSI may not be used with DBMS=V6

ORA-19634: filename required for this function

PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF.

DRG-50908: invalid maximum number of documents string

RMAN-08124: keep attributes for the datafile/controlfile copy are changed

QSM-02075: materialized view on synonym

IMG-00701: unable to set the properties of an empty image

For more Oracle Errors Interview Questions Click Here