Re: How to retrieve rows in the insertion order?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 19 Feb 1999 21:15:28 GMT
Message-ID: <36e1d443.30988418@192.86.155.100>

A copy of this was sent to kittu_at_Hawaii.Edu (Chakravarthy KM Nalamotu) (if that email address didn't require changing) On 19 Feb 1999 20:46:13 GMT, you wrote:

>Hello Users,
>Does a SELECT statement without a where criteria retrieves
>rows in the order the rows were inserted?
>Problem is, we would like to retrieve data by time criteria. But,
>there is no timestamp in the date field.
>Thank you for your responses.
> Kittu.

No it does not. Rows will be retrieve in some order but definitely not always in the order of insertion. Unless there is some column by which to order the data by with an order by statement -- the data comes out as it pleases.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Feb 19 1999 - 15:15:28 CST