Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Weird Query

Re: Weird Query

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 02 Aug 2005 08:24:06 -0700
Message-ID: <1122996231.839147@yasure>


Maxim Demenko wrote:
> DA Morgan schrieb:
>

>> Maxim Demenko wrote:
>>
>>> 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
>>
>>
>>
>> Actually, given the multicultural status of the Americas you will find
>> Americans with a number of middle names between 0 and 5 without too
>> much trouble: I know an Oracle DBA at Cingular Wireless with 3.
>>
>> What to do ... what to do?

>
>
> You see indeed a difference between your approach
> <snip>
> The only solution is to have a single character string with
> values such as Y(es) or N(o) to indicate how the business
> rule is to be applied to the row.
> </snip>
>
> and mine ?
> <snip>
> Regarding distinguishing of values which Oracle doesn't distinguish
> itself , i think there is no way except introducing an additional attribut.
> </snip>
>
> Best regards
>
> Maxim

On introducing an additional attribute we agree so I am perlexed by what you've written: I think it the only solution if one should decide any is required.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Aug 02 2005 - 10:24:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US