Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00423: ORDER BY item must be the number of a SELECT-list
expression
- 1 Answers
- 3623 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 |
ORA-09955: scgcan: unexpected return status when canceling a lock
IMG-00714: internal error
ORA-31046: Incorrect argument(s) specified in the operator
QSM-02069: PCT not supported with multi-column partition key
ORA-13347: the coordinates defining an arc are not distinct
ORA-26563: renaming this table is not allowed
ORA-33004: (XSAGDNGL01) workspace object is not a relationship array.
NNL-00271: Default domain is now "string"
DRG-12438: document table release failed
ORA-16220: no failed transaction found
ORA-02246: missing EVENTS text
IMG-00813: boundary queue free failed
Oracle Errors 
