Re: building sets in SQL92

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

This works in OCELOT, which markets itself as 'the only Database Management System (DBMS) that supports the full ANSI / ISO SQL Standard (1992)' plus some of SQL 99 'and absolutely no deviations or extensions'. If you believe them...
(http://ourworld.compuserve.com/homepages/OCELOTSQL/).

Incidentally, I know the official SQL standards from 1989 onwards are not freely available 'for copyright reasons' (something stupid like $18 for a chapter of SQL99 in PDF!) . However, I cannot get the 1986 standard from http://case50.ncsl.nist.gov/sql-86, which loads of webpages seem to point to. It keeps asking for a password - anonymous doesn't work - does anybody know? Is it supposed to be restricted? The web pages I've been to imply not.

It seems stupid that the standards documents are not freely available. Surely if they were then we would program more by the standard, for more compatible code, instead of by the manufacturer's language guide. Received on Fri Jun 01 2001 - 23:44:34 CEST