Re: Order BY Cluase on View

Mark Townsend <markbtownsend@attbi.com> wrote in message news:<3F87788C.1080702@attbi.com>... > > > > Any application that takes advantage of an ordered by VIEW is a very bad > > written application from my point of view. > > > > Order By support was added to the view definition in Oracle (and I > believe in DB2 and the standard) to support the use of the order by > clause in an inline view definition. ORDER BY in view definitions is not included in the SQL standard SQL-99, or in SQL-2003 (draft). An easy way to find out if an SQL statement is standard compliant is to use the SQL Validator, a free online tool verifying SQL standard compliance: http://developer.mimer.com/validator/ It has support for SQL-92, SQL-99, and SQL-2003 (draft). Regards, Jarl

Jarl Hermansson wrote: > Mark Townsend <markbtownsend@attbi.com> wrote in message > news:<3F87788C.1080702@attbi.com>... >> > >> > Any application that takes advantage of an ordered by VIEW is a very >> > bad written application from my point of view. >> > >> >> Order By support was added to the view definition in Oracle (and I >> believe in DB2 and the standard) to support the use of the order by >> clause in an inline view definition. > > ORDER BY in view definitions is not included in the SQL standard > SQL-99, or in SQL-2003 (draft). Heh, that Townsend's got such a firm grip on things, he could work for Informix marketing. :o) -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"