db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Overly conservative on reserved words?
Date Tue, 01 Mar 2005 21:27:28 GMT
Yes, I meant Oracle 10g... Does it support UNION DISTINCT? I thought
not, based on their documentation. They seem to have a MINUS, which may
map to EXCEPT.

Satheesh

Edward Rayl wrote:

> Satheesh Bandaram wrote:
>
>> Take for example, the recently
>> added UNION/INTERSECT DISTINCT clause. This doesn't add any new
>> functionality to Derby, since the default is the DISTINCT. Having this
>> syntax will create problems for migrating to DB2, Oracle, Informix. (I
>> only briefly searched for support in Oracle 10i database. They don't
>> seem to have it.)
>>
> Oracle 10g does not support the ANSI EXCEPT operator. It does support
> UNION and INTERSECT. However, it does not support the use of the ALL
> keyword with those set operators. However, Oracle does intend to
> support all the ANSI set operators and their keywords in a future
> release.
>
> A minor note -- you really meant Oracle 10g, not 10i
>
>
>


Mime
View raw message