Re: NLS_COMP & NLS_SORT issues in Oracle 10g Release 2

On Thu, 05 Jul 2007 20:55:24 +0200, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>stvchien0_at_gmail.com wrote:
>>
>> select *
>> from test_for_bug t
>> WHERE ((T.status <> 'Deleted') AND (T.status <> 'Pass') AND
>> (T.requireddate >= '2007-07-04 00:00:00'))
>> OR ((T.status = 'Pass'))
>> OR ((T.status <> 'Pass') AND (T.status <> 'Deleted') AND
>> (T.requireddate < '2007-07-04 00:00:00'))
>> OR ((T.status = 'Deleted'));
>>
>>
>> select *
>> from test_for_bug t
>> WHERE ((T.status <> 'Deleted') AND (T.status <> 'Pass') AND
>> (T.requireddate >= '2007-07-04 00:00:00'))
>> OR ((T.status = 'Pass'))
>> OR ((T.status <> 'Pass') AND (T.status <> 'Deleted') AND
>> (T.requireddate < '2007-07-04 00:00:00'))
>> OR ((T.status = 'Deleted'));
>>
>> We got,
>
>>
>> We wondered why we got two different results...
>>
>> - Steve
>
>I see no order by clause in either statement.
>The order in which rows are retrieved is random; if you want
>then ordered, use an order by clause. Basic SQL class, day 1,
>before lunch break.

Hi,

  Actually, we wondered why the same SQL statement returned different number of rows (not the order) back to us...

  Any clue? Thanks!

• Steve