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 |
QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query
TNS-02514: Invalid packet received
ORA-06900: CMX: cannot read tns directory
ORA-02300: invalid value for OIDGENERATORS
ORA-24322: unable to delete an initialized mutex
ORA-12026: invalid filter column detected
DRG-11860: Connection Establishment Interrupted
LSX-00164: no content specified in "~S"
ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
ORA-06575: Package or function string is in an invalid state
ORA-24440: OCI Easy Install mode cannot be initialized
ORA-14062: one or more of table's partitions reside in a read-only tablespace