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-14168: only one subpartition may be modified

ORA-28047: database is not a member of any enterprise domain in OID

PCB-00314: DECLARE DATABASE is an Oracle extension

ORA-08414: error encountered in string

ORA-31052: Cannot delete ACL with other references

TNS-01001: start [<listener_name>] : start listener

ORA-22280: no more buffers available for operation

ORA-37117: olapi history retention has been disabled

ORA-02827: Invalid file number

ORA-23607: invalid column "string"

ORA-16951: Too many bind variables supplied for this SQL statement.

DRG-10305: pipe string is full

For more Oracle Errors Interview Questions Click Here