Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: materialized views and ORDER BY
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-lReceived on Wed Apr 25 2007 - 11:43:29 CDT
![]() |
![]() |