|
|
Archives of the TeradataForum
Message Posted: Mon, 19 Jul 2004 @ 16:59:31 GMT
Subj: | | Re: Is there an equivalent of DUAL in Teradata |
|
From: | | Victor Sokovin |
| In Oracle I used to make use of a system table called "dual" which had 1 row with the letter x as the value. It was handy if you wanted to
add literals onto a query result as you could use "union select 'some literal' from dual;" onto the end of the select query. | |
| Is there an equivalent in Teradata? | |
There was a thread on this recently:
www.teradataforum.com/teradata/20040504_183807.htm
Regards,
Victor
| |