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-32579: password for SYSTEM already specified

1 Answers  


ORA-09870: spini: failure initializing maximum number of open files.

1 Answers  


ORA-23345: table "string"."string" not registered to collect statistics

1 Answers  


RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset

1 Answers  


ORA-12059: prebuilt table "string"."string" does not exist

1 Answers  






LSX-00294: field "~S" produced multiple hits

1 Answers  


ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers  


ORA-26027: unique index string.string partition string initially in unusable state

0 Answers   MeritTrack,


ORA-00334: archived log: 'string'

1 Answers  


ORA-02218: invalid INITIAL storage option value

1 Answers  


PCC-02352: out of bounds bind position from PL/SQL

1 Answers  


RMAN-10001: error parsing recovery catalog connect string "string"

1 Answers  


Categories