Re: sort order on VIEWs ?

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Wed, 20 Apr 2011 11:37:59 -0700
Message-ID: <BANLkTimEt_1EPg4+15KO6Rp+J1+0Djjr4g_at_mail.gmail.com>

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_at_ppoone.com>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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Michael Moore
> *Sent:* Wednesday, April 20, 2011 1:20 PM
> *To:* oracle-l_at_freelists.org
> *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.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 20 2011 - 13:37:59 CDT