Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01791: not a SELECTed expression

349402Apr 8 2004 — edited May 29 2011
Let's say I want a list of employee names ordered by their birthdate. I don't want to actually see the birthdate in the results of the query though. I know that in the past on other Oracle 9i databases I was allowed to order by columns that aren't in the select list.

On my current database I get the error "ORA-01791: not a SELECTed expression" when I try that. Is there a parameter or something that is stopping me?

Any help would be appreciated,
Chris S.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2011
Added on Apr 8 2004
5 comments
87,287 views