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 |
ORA-16034: FROM parameter is incompatible with MANAGED recovery
LSX-00103: duplicate group "~S"
ORA-19657: cannot inspect current datafile string
ORA-30659: too many locations specified for external table
RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset
ORA-07628: smsfre: sga not mapped
ORA-38419: invalid identifier in attribute : string
ORA-13266: error inserting data into table string
ORA-22913: must specify table name for nested table column or attribute
ORA-28665: table and partition must have same compression attribute
RMAN-08070: deleted datafile copy
ORA-34363: (MXDSS13) number other user writing