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

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_COMP & NLS_SORT issues in Oracle 10g Release 2

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

From: <stvchien0_at_gmail.com>
Date: Fri, 06 Jul 2007 09:04:06 +0800
Message-ID: <q55r83dl4b6idcm5mp6ef5r8vgu06tcvig@4ax.com>


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!

Received on Thu Jul 05 2007 - 20:04:06 CDT

Original text of this message

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