Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01785 – ORDER BY item must be the number of a SELECT-list expression

Oracle Database Error Code ORA-1785 Description :

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

Error Cause:

Either an ORDER BY item for a set expression is not a column number, or the ORDER BY item is not the number of a SELECT list column.

How to Solve :

The ORDER BY item must be a number between 1 and the number of columns in the SELECT list. Check the column number and retry the statement.