Yea, I was gonna ask you the question ........ why would you include an order by in a view ? ________________________________ From: Michael Moore [mailto:michaeljmoore@xxxxxxxxx] Sent: Wednesday, April 20, 2011 1:38 PM To: Lange, Kevin G Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: sort order on VIEWs ? Thanks kevin. Since asking the question I did some digging. http://en.wikipedia.org/wiki/View_(database) 4th paragraph The take-away is that you can do it in Oracle, but it's not standard and probably not a good idea. Regards, Mike On Wed, Apr 20, 2011 at 11:34 AM, Lange, Kevin G <kevin.lange@xxxxxxxxxx> wrote: Not sure about a Guarantee, but, in my tests, as long as I did not include an order by on the query contrary to the order by on the view, I got my data in the order of the views order by. Of course, it was a small sampling of data. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Moore Sent: Wednesday, April 20, 2011 1:20 PM To: oracle-l@xxxxxxxxxxxxx Subject: sort order on VIEWs ? If a VIEW has an ORDER BY clause, am I guaranteed to get that sort order when I use the VIEW (provided of course that I don't specify a different sort order)? Regards, Mike This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.