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.

Other related posts: