PLS-00423: ORDER BY item must be the number of a SELECT-list
expression
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 |
CLSS-00200: local node string not listed in configuration
ORA-02461: Inappropriate use of the INDEX option
QSM-00767: a SQL cache is not available to user string
ORA-06924: CMX: wrong break message length
ORA-30929: ORDER SIBLINGS BY clause not allowed here
TNS-00134: Missing COMMUNITY component in addresses for the Navigator in TNSNAV.ORA
KUP-02006: script line too long
RMAN-08549: database name (or lock name space) used for search: string
ORA-21301: not initialized in object mode
ORA-19323: Invalid url string
DRG-10517: index string is already valid
ORA-16169: LGWR network server invalid parameters