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-39059: dump file set is incomplete

ORA-27204: skgfpqr: sbtpcqueryrestore returned error

ORA-30647: error retrieving access parameters for external table string.string

ORA-02720: osnfop: shmat failed

ORA-18010: command missing mandatory CATEGORY keyword

ORA-22314: method information mismatch in ALTER TYPE

ORA-24152: cannot drop evaluation context string.string with dependents

ORA-23462: flavor string in use at site string

SQL*Loader-00267: Control file must be first data file.

QSM-01064: query has a fixed table or view

TNS-12677: Authentication service not supported by database link

ORA-02221: invalid MAXEXTENTS storage option value

For more Oracle Errors Interview Questions Click Here