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

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