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
- 3643 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 |
PLW-05001: previous use of 'string' (at line string) conflicts with this use
ORA-01060: array binds or executes not allowed
ORA-02309: atomic NULL violation
TNS-00115: Could not allocate pump global buffers
ORA-28047: database is not a member of any enterprise domain in OID
RMAN-06205: Uncataloged string objects
ORA-06011: NETASY: dialogue too long
ORA-24033: no recipients for message
ORA-10582: The control file is not a backup control file
NZE-28789: name type not found
DRG-52110: error in writing extended knowledge base
ORA-38504: this operator not allowed with the configured attribute set
Oracle Errors 
