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 |
PCB-00637: Host variable is not an exact binary integer
PCC-02426: Incompatible LOB types
QSM-00760: the import mode string is invalid for the current operation
PCB-00108: Unable to open list file "string"
ORA-09879: sstascre/sstasat: shmat error, unable to attach tas read page
ORA-02051: another session in same transaction failed
LPX-00220: the string "]]>" cannot occur in character data
ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
NNL-00516: Displays complete server status
ORA-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
QSM-02138: agg(expr) requires correspondng agg(expr*expr) function
ORA-07757: slemcc: invalid handle