OraFAQ Forum: Reports & Discoverer » ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi

Home » Developer & Programmer » Reports & Discoverer » ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi (disc 10.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #422755]

Fri, 18 September 2009 13:52

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

When i'm sorting on a calculated field i'm getting the following error:

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

Please any help?

Thanks

Report message to a moderator

Re: ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #422768 is a reply to message #422755]

Fri, 18 September 2009 23:37

shaz
Messages: 182
Registered: June 2009

Senior Member

This generally occurs when you are using a column alias which is used in the ORDER BY clause of a SELECT statement that uses a UNION, INTERSECT, or MINUS set operator.

Report message to a moderator