ORA-01791
not a SELECTed expression
Cause
There was an incorrect ORDER BY item. The query was a SELECT DISTINCT query with an ORDER BY clause. In this context, all ORDER BY items must be constants, SELECT list expressions, or expressions whose operands were constants or SELECT list expressions.
Action
Remove the inappropriate ORDER BY item from the SELECT list and retry the statement.