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-19686: SPFILE not restored due to string

PCC-00136: Invalid SQL_CURSOR declaration

NNL-00411: Minimum response time: string

ORA-13009: the specified date string is invalid

ORA-13194: failed to decode supercell

ORA-14135: a LOB column cannot serve as a partitioning column

RMAN-08002: starting full resync of recovery catalog

ORA-28602: statement not permitted on tables containing bitmap indexes

ORA-18000: invalid outline name

ORA-12630: Native service operation not supported

TNS-12544: TNS:contexts have different wait/test functions

ORA-16096: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY

For more Oracle Errors Interview Questions Click Here