Re: materialized views and ORDER BY
- From: "Greg Norris" <spikey.mcmarbles@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Apr 2007 11:43:29 -0500
On 4/25/07, Kerber, Andrew W. <Andrew.Kerber@xxxxxxx> 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.