Re: Query sorting without Order by

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 05 Feb 2001 04:41:34 GMT
Message-ID: <2aqf6.376288$U46.11115697@news1.sttls1.wa.home.com>

Without order by (in any database) the results are unspecified as to what order they come back in. It maybe in some cases that the rows come back in the order you desire, however, that may not always be true. Why don't you want to specify what order you want the data in? Jim

"Putrasto" <putasto_at_mmedia-i.com> wrote in message news:qpCf6.13434$K6.105746_at_news...
> Hallo all...
>
> I want to make sql query (in stored procedure) to select rows,
> and i want the selected rows automatically ordered (ascending or
> descending),
> without keyword 'order by' in the query .
> Is that possible in oracle?
> my friends told me that he ever done that in MS SQL using index
> in its table (design).
>
> Thank in advance.
>
>
Received on Sun Feb 04 2001 - 22:41:34 CST