PLS-00423: ORDER BY item must be the number of a SELECT-list
expression
- 1 Answers
- 3331 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-01943: IDENTIFIED BY already specified
PCC-02450: Cursor was not declared in scrollable mode
ORA-16771: Converting physical standby to primary failed in the failover operation.
TNS-04067: Number of connections: number.
ORA-25504: the system is already in quiesced state
ORA-31057: Display Name of the element being inserted is null
PCB-00222: Size for host variable string exceeds maximum size
PCC-02301: cannot reopen input file for reading
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
PLS-00728: the limit of a VARRAY can only be increased and to a maximum 2147483647
ORA-01463: cannot modify column datatype with current constraint(s)
DRG-10550: illegal syntax for index, preference, source or section name
Oracle Errors 
