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
- 3726 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-30363: columns in a dimension column list must be in the same relation
ORA-12730: invalid equivalence class in regular expression
ORA-29854: keyword BITMAP may not be used in creating domain indexes
TNS-00306: Connection Manager encountered an invalid/unknown trace level
ORA-30394: source statement identical to the destination statement
RMAN-00554: initialization of internal recovery manager package failed
TNS-00257: Number of Successful Requests : number
ORA-22911: duplicate storage specification for the nested table item
O2U-00209: Attribute or function name to be translated was not found
ORA-29530: could not create shortened name for string
ORA-28576: lost RPC connection to external procedure agent
PCC-00028: Option "string" not legal as EXEC ORACLE OPTION
Oracle Errors 
