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
