Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results
>
> The two groups above can each have many, many members. But there may
> be only a few members (the xxxx) that belong to both groups ( the
> "and" operator in your case).
>
You're completely right but e.g. use calculator and you understand. You just didn' read the example carefully enough. When I said we are not beginners I meant that.
By common sense I meant that if there are 10 customers in a database and 8 of them are 'ACTIVE' and 8 of them <> 'PERSON' that means that there must be more than 1 customers that are both 'ACTIVE' AND <> 'PERSON'. Both columns has NOT NULL constraint.
This is just a basic example, please don't argue with other possibilities, I understand.
001 NOTACTIVE 'PERSON' 002 NOTACTIVE 'PERSON' 003 ACTIVE 'NOTPERSON' 004 ACTIVE 'NOTPERSON' 005 ACTIVE 'PERSON' 006 ACTIVE 'PERSON' 007 ACTIVE 'PERSON' 008 ACTIVE 'PERSON'
And we haven't figured this out yet. First we thought this might be an index problem but it's not. Now I'm trying to figure out what kind of a character set problem might cause this. Refer to my other posts to see what I mean.