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

ORA-24907: invalid pair of callback and recepient protocol attributes

1 Answers  


ORA-03252: initial extent size not enough for LOB segment

1 Answers  


TNS-00208: Logging : string

1 Answers  


DRG-50915: last document number string is not an integer

1 Answers  


DRG-11122: unsupported section group

1 Answers  






NNL-01076: Operational Status number

1 Answers  


KUP-04012: file length is too large for output field

1 Answers  


ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.

1 Answers  


ORA-00089: invalid instance number in ORADEBUG command

1 Answers  


ORA-25244: dequeue index key not found, QUEUE string, rowid string

1 Answers  


PLS-00390: undefined column 'string' in INSERT statement

1 Answers  


PLS-00225: subprogram or cursor 'string' reference is out of scope

1 Answers  


Categories