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-01073: materialized view, string, has a join not found in query
ORA-28104: input value for string is not valid
ORA-02777: Stat failed on log directory
TNS-04072: Unable to suspend atleast one of the gateways.
IMG-00712: unable to write to destination image
ORA-13462: invalid blocking specification
ORA-00032: invalid session migration password
ORA-13430: the GeoRaster object has null attribute(s)
ORA-06923: CMX: illegal break condition
ORA-07573: slkhst: could not perform host operation
O2I-00129: No Java file specified
ORA-01353: existing Logminer session