 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 Jul 2004 @ 08:33:27 GMT
| Subj: | | Re: Is there an equivalent of DUAL in Teradata |
| |
| From: | | Victor Sokovin |
Michael,
| | 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.
Regards,
Victor
| |
