PLS-00423: ORDER BY item must be the number of a SELECT-list
expression
- 1 Answers
- 3109 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A column alias was used in the ORDER BY clause of a
SELECT statement that uses a UNION, INTERSECT, or MINUS set
operator. This is not allowed. In such cases, expressions in
the ORDER BY clause must be unsigned integers that designate
the ordinal positions of select-list items.
Action: Change the alias in the ORDER BY clause to an
unsigned integer that designates the ordinal position of the
select item in question.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
SQL-02147: ANSI Dynamic occurrence value out of range
LSX-00213: only ~1d occurrences of particle "~2S", minimum is ~3d
ORA-29305: cannot point-in-time recover tablespace 'string'
ORA-25153: Temporary Tablespace is Empty
ORA-29265: HTTP header not found
CLSR-00527: OCR operation failed
ORA-27365: job has been notified to stop, but failed to do so immediately
SQL*Loader-00560: error reading file
ORA-16638: could not get the instance status
ORA-35076: (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.
ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.
ORA-31047: Could not retrieve resource data at path string
Oracle Errors 
