Hi all
While working on Oracle I came across a situation where I need to select the rows from a table in which the recently inserted row should be at the top of my selection.
But here in my table I am not using any Identity column. I know how to do the same when there is an Identity column present, but is there any way to do this without Identity column?
Asked
Active
Viewed 68 times
0
shary.sharath
- 649
- 2
- 14
- 29
-
Do you have some timestamp in your table. – Ankit Bajpai May 06 '15 at 11:44
-
You must have a `timestamp` column for such sorting. – Lalit Kumar B May 06 '15 at 11:44
-
1Somewhat related to your question is http://stackoverflow.com/questions/899514/default-row-ordering-for-select-query-in-oracle – shahkalpesh May 06 '15 at 11:46
1 Answers
1
Unless you have a sequential ID or Timestamp or some other field you can ORDER BY, Oracle provides no guarantee of order and you should not rely on it.
Chris Cameron-Mills
- 4,587
- 1
- 27
- 28