ORA-01785
ORDER BY item must be the number of a SELECT-list expression
Cause
Either an ORDER BY item for a set expression was not a column number, or the ORDER BY item was not the number of a SELECT list column.
Action
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.
ORA-01785
ORDER BY item must be the number of a SELECT-list expression
Cause
Either an ORDER BY item for a set expression was not a column number, or the ORDER BY item was not the number of a SELECT list column.
Action
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.
ORA-01785
ORDER BY item must be the number of a SELECT-list expression
Cause
Either an ORDER BY item for a set expression was not a column number, or the ORDER BY item was not the number of a SELECT list column.
Action
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.
