>>Oracle supports ORDER BY in views and has for several versions. Is there any reason why I should not use it?
>
>What benefits do you get by using views with ORDER BY clause?
>
>It's not a part of ANSI SQL standard and may not be available in other databases.
>Also a query w/o ORDER BY clause is not suppose to return records in any particular order. IOW, if you switch FROM from a view to a table you'll get different result which is inconsistent.
All the database vendors add extensions to their database offerings.
But in our case, the users like to use views to analyze their data and they prefer to be able to view it in a particular order,
I believe this is another example of something Oracle can do and SQL Server can't. I am not trying to start an argument over the last statement rather just stating my opinion, :)
Regards,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!