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-09711: orasrv: archmon already connected.

ORA-21700: object does not exist or is marked for delete

ORA-01353: existing Logminer session

IMG-00911: free basic data structure failed

ORA-01202: wrong incarnation of this file - wrong creation time

ORA-09939: Restoration of signal handlers failed.

ORA-31071: Invalid database username or GUID string

ORA-25271: queue table not found for the given queue

NNL-00507: Shows, sets, or cancels the time when an auto-refresh query is next issued

ORA-12825: explicit degree of parallelism must be specified here

RMAN-03020: asynhronous RPC test will take 1 minute

ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.

For more Oracle Errors Interview Questions Click Here