How to fix the Oracle error PLS-00423: ORDER BY item must be the number of a SELECT-list expression?

In this post, you’ll learn more about the Oracle ErrorPLS-00423: ORDER BY item must be the number of a SELECT-list expression with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error PLS-00423: ORDER BY item must be the number of a SELECT-list expression ?

You can fix this error in Oracle by following the below steps

Change the alias in the ORDER BY clause to an unsigned integer that designates the ordinal position of the select item in question.