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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Record order in SELECT .. IN ( , , , ) queries

Re: Record order in SELECT .. IN ( , , , ) queries

From: Tony <andrewst_at_onetel.net.uk>
Date: 26 Jan 2004 09:20:56 -0800
Message-ID: <c0e3f26e.0401260920.55ad057e@posting.google.com>


submit_at_galleus.com (Kurta) wrote in message news:<efcb1994.0401260151.7216f23c_at_posting.google.com>...
> When I start a SELECT IN query like this:
>
> SELECT USR_ID, USR_NAME FROM T_USR WHERE USR_ID IN (4, 2, 5, 1, 3);
>
> Is there a guaranteed result record order? I tried these queries and
> (using Oracle 9i) it always returned the results in reverse order (not
> the phisical order):
>
> USR_ID USR_NAME
> ----------------------------------------------
> 3 a
> 1 a
> 5 a
> 2 a
> 4 a
>
> Can I assume that this order is always the same? Is there a technical
> documentation about this?
>
> Thanks,
>
> Kurta

"Assume makes an ass of u and me" as they say.

No: if you want a specific order you have to ask for it. Received on Mon Jan 26 2004 - 11:20:56 CST

Original text of this message

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