Re: Weird Query

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 02 Aug 2005 10:28:46 +0200
Message-ID: <42ef2fd3$0$11757$9b4e6d93@newsread4.arcor-online.net>

Marian Aldenhövel schrieb:
> Hi,
>
> > If you will distinguish that rows, you should recognize, that a ability
>

>> to posess a middle name is only due to affiliation of certain person 
>> to certain category of people ( nation, whatever ).

>
>
> So there are no americans that do not have a middle name?
>
> The only safe category I could think of would be "people who have middle
> names" vs. "people who do not have middle names". So another column would
> be in order and that feels redundant to me.
>
> Ciao, MM

You are probably right, i'm not so familiar with details of naming of americans...
Regarding distinguishing of values which Oracle doesn't distinguish itself , i think there is no way except introducing an additional attribut.

Best regards

Maxim Received on Tue Aug 02 2005 - 03:28:46 CDT