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 |
TNS-12655: Password check failed
ORA-12622: TNS:event notifications are not homogeneous
TNS-01052: The command completed successfully
ORA-24314: service handle not initialized
ORA-25445: invalid column number: string for table alias: string
ORA-13009: the specified date string is invalid
ORA-06251: NETNTT: cannot translate address file name
ORA-01891: Datetime/Interval internal error
ORA-14036: partition bound value too large for column
NID-00507: APPEND Append to output log NO
RMAN-06300: Report of files with less than number redundant backups
NNL-00536: set|show requests_enabled [<on|off>] [<server_list>] : enable, disable or show server request processing