Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 28 Feb 2004 @ 10:25:23 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Derived tables on V2R5
 
From:   Dieter Noeth

Victor Sokovin wrote:

  1. It looks like this new syntax form proved to be useful and it has been adopted by ANSI. In Oracle, derived tables are known as "inline views" and have been around for some time. SQL Server supports them too. So, as a syntax form these "unnamed views" are likely to stay. I agree with you here.  


What do you mean by "new syntax"?

Derived tables have been part of SQL (at least) since SQL-92, but not part of Entry Level (Full Level in SQL-92).

Btw, in SQL:1999 it's still not part of Core SQL (Feature F591)


Dieter



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016