Re: Create Table

From: Don Macpherson <nearly_donmac_at_almost_erols.com>
Date: 1998/07/08
Message-ID: <6o1dhs$so7$1@winter.news.erols.com>#1/1

Johnnie,

Presumably 2> fails on Oracle due to the single extraneous comma at the end of the first line.

According to the SQL92 standard (Entry, Intermediate or Full), this should fail.

Don Macpherson

Johnnie Isg wrote in message ...
>I am testing two create table statements in different databases. I want
>to know if they are SQL92 or SQL3 Standard Compliance statements
>
>1>
>create table a ( a int, b int ,
>constraint a primary key (a)
>)
>
>2>
>create table a ( a int, b int ,
>--constraint a primary key (a)
>)
>
>Results:
>
>Oracle:
>1>OK
>2>Fail
Received on Wed Jul 08 1998 - 00:00:00 CDT