Search notes:

ORA-01791: not a SELECTed expression

The following query throws a ORA-01791: not a SELECTed expression because the order by uses an expression which is not in the select list of the statement:
select distinct
   substr(object_name, 1, 3)
from
   user_objects
order by
   object_name;

See also

Other Oracle error messages

Index