Re: In-line views
Date: 8 Dec 2001 09:51:08 -0800
Message-ID: <c0d87ec0.0112080951.6abe0364_at_posting.google.com>
>> I've recently noticed that the in-line view SQL syntax used by
Oracle does not work in Sybase. Are in-line views an SQL extension
only supported by Oracle, or have other DBMSs failed to implement the
SQL standard? <<
When you say "in-line views" do you mean derived tables? The syntax is
<tabular query expression> AS <table name> [<column name list>]
SQL server and DB2 have this feature now. There are some scoping rules that apply to a derived table. Basically, once it has a name of its own, you cannot reference the names of tables inside it in the containing queries any more. While a derived table is supposed to act as if it was materialized, the optimizer can expand it in line if that will not change the results. Received on Sat Dec 08 2001 - 18:51:08 CET