building sets in SQL92

From: Sten Loecher <sten-loecher_at_gmx.de>
Date: Sat, 21 Jul 2001 23:27:46 GMT
Message-ID: <9f5n16$7cv$1@kastor.inf.tu-dresden.de>

Hi folks,

I need to write a query in SQL92 that builds a set "on the fly" for use as kind of temporary table. For example, in Oracle SQL I could write:

select 'Boston' as CITY from DUAL
union
select 'Atlanta' as CITY from DUAL
union
select 'Columbia' as CITY from DUAL

with DUAL as a table that has one column and one row, because I must specify some table.
The result of this query would be:

CITY

---

Boston
Atlanta
Columbia

In SQL92 one can write this query too, which told me the according grammar. The specification of a table is also mandatory. What I'm thinking about is, wheter the semantic is supposed to return the same result like in Oracle or wheter such a such a query is allowed at all. Maybe there is still another way to build such a set in SQL92, isn't it ?

Would appreciate any help.

Sten Received on Sat Jul 21 2001 - 18:27:46 CDT