Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 08:33:27 GMT

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

Subj:   Re: Is there an equivalent of DUAL in Teradata
From:   Victor Sokovin


  The good news in Teradata SQL is that the FROM is option. As a result, literals can be SELECTed out of thin air. So, you can do exactly the same thing as you have done in Oracle (and others) without having a ficitious, hockey made up table to reference. Much better I think.  

Some set operations like MINUS, INTERSECT and UNION would want to have a table in this case (and, therefore, a FROM clause), as was pointed out in the thread I quoted earlier. There are other situations when the table is expected. So, there is no way to always avoid making a DUAL-like table. The advantage of Oracle is that the table is standard. With TD every site must probably agree on their naming conventions for such tables so that they are easily recognizable by all interested parties.



  <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: 15 Jun 2023