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

Home -> Community -> Usenet -> c.d.o.tools -> OR and sequence of results

OR and sequence of results

From: <rjones_at_cincom.com>
Date: 2000/07/11
Message-ID: <8kfbjl$kr5$1@nnrp1.deja.com>#1/1

I've recently noticed that in the absence of any other sequencing, the position of OR statements will influence the sequence of results for a simple query. Take a single column table X with values 'A', 'B' and 'C', the query...

select rownum, col from x where col = 'A' or col = 'B' or col = 'C'

...will give:

   ROWNUM COL
--------- ---

        1  C
        2  B
        3  A

But...

select rownum, col from x where col = 'C' or col = 'B' or col = 'A'

...will give:

   ROWNUM COL
--------- ---

        1  A
        2  B
        3  C

This doesn't seem to be documented anywhere. It's a potentially useful feature, if indeed it is a feature is not going to be 'fixed' in the next release.

Any thoughts???

Rod

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 11 2000 - 00:00:00 CDT

Original text of this message

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