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

QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

TNS-01201: Listener cannot find executable string for SID string

PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

NNO-00056: warning: domain minimum TTL must be between number and number, set to number seconds

DRG-10549: length of the object name string exceeded the limit

CLSR-00510: Unable to load NLS data

NZE-28757: system attempt to allocate 0 bytes of memory

TNS-12203: TNS:unable to connect to destination

PCC-02339: host variables cannot be of union types

RMAN-06014: command not implemented yet: string

TNS-00038: INTCTL: Poorly formed address or command string

ORA-12492: DBLOW cannot be changed

For more Oracle Errors Interview Questions Click Here