Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: materialized views and ORDER BY

Re: materialized views and ORDER BY

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Wed, 25 Apr 2007 11:43:29 -0500
Message-ID: <d4beff360704250943t36fd264eye1a192abc71441d@mail.gmail.com>


On 4/25/07, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:
>
> Perhaps he could resolve the problem by creating a standard view of the
> materialized view…
>

My thoughts exactly! :) I told him that the "most correct" fix would be to update the application code and include an explicit ORDER BY, but wrapping it in a conventional view would be an easy/effective workaround.

-- 
"I'm too sexy for my code." - Awk Sed Fred.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 11:43:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US