Use of order by clause in materialized view
463053Oct 27 2005 — edited Oct 28 2005Can a materialized view definition have an order by clause?
If yes, does the use of an order by clause add any significance to a materialized view definition (Will the data shown be ordered by the column mentioned or will it be displayed in the default order anyway)
Im not able to create a materialized view in my instance, but am able to create it if i remove the order by clause.
Expert advice please!