Forum OpenACS Q&A: Re: problem for sorting records in oracle 10g

Collapse
Posted by Brian Fenton on
Hi Mandar,

you should also use an ORDER BY clause if you need data sorted as otherwise you risk getting the data back in a random order. I think it was just a coincidence in Oracle 9i. See this article from Tom Kyte for more info http://tkyte.blogspot.com/2005/08/order-in-court.html

Brian