ORA-30487: ORDER BY not allowed here



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

Post New Answer

More Oracle Errors Interview Questions

AMD-00141: parameter string of "string" not valid starting around "string"

1 Answers  


ORA-16061: Log file status has changed

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


ORA-32619: incorrect use of MODEL ITERATION_NUMBER

1 Answers  


DRG-12803: invalid text datatype

1 Answers  






SQL*Loader-00434: Can not load LOB/XML in a nested table along with the parent table.

1 Answers  


ORA-01685: max # extents (string) reached in index string.string partition string

1 Answers  


ORA-09940: ORACLE password file header is corrupt

1 Answers  


ORA-19012: Cannot convert XML fragment to the required datatype

1 Answers  


RMAN-04016: could not get OCI error handle

1 Answers  


LFI-01518: write() failed(OSD return value = string) in string.

1 Answers  


ORA-29387: no top-plans found in the pending area

1 Answers  


Categories