PLS-00423: ORDER BY item must be the number of a SELECT-list expression

PLS-00423: ORDER BY item must be the number of a SELECT-list
expression

Question Posted / guest

1 Answers
3072 Views
I also Faced
E-Mail Answers

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

Post New Answer