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

-----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.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGjT6cLw8L4IAs830RAtZ4AJ9Drb/5XCTCmrS0rdpIaDj0Y60VdACfcS4x MVtLmvVzPb9N90EMl/FsEm4=
=A5AH
-----END PGP SIGNATURE----- Received on Thu Jul 05 2007 - 13:55:24 CDT