db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Rayl <er...@bellsouth.net>
Subject Re: Overly conservative on reserved words?
Date Tue, 01 Mar 2005 22:13:18 GMT
Oracle 10g supports
UNION
UNION ALL
INTERSECT
MINUS

It does not support UNION DISTINCT, although UNION behaves as if it were 
UNION DISTINCT.

I have not used EXCEPT, but I am assuming, as well, that it maps to MINUS.



Satheesh Bandaram wrote:

>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