Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2004 @ 12:40:31 GMT


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


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

Frank,

  Using derived tables can overcome this one. See below:  


  select * from (select 'hello' (char(10)) ) t (c1)
union
select * from (select 'bye-bye' (char(10))) t (c1) ;
 



Great but all this has already been discussed in

www.teradataforum.com/teradata/20040504_183807.htm


and I gave that reference earlier in the thread. I did not expect that the thread would need to be repeated with all the details again.

Some contributors in the current thread have said that the fact that TD does not need the FROM clause takes care about the Oracle DUAL functionality. Well, I think it does not as the examples with UNION, MINUS and other set operations show (they contain derived tables and FROM clauses!). That was the simple point I wanted to make in my earlier postings today. I was not looking for solutions for the UNION example as such.

If somebody was interested in the solutions, they were already listed by Dieter in the thread above.


Regards,

Victor



     
  <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