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

Home -> Community -> Usenet -> c.d.o.server -> Re: fast select of first row on Oracle table...

Re: fast select of first row on Oracle table...

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 4 Mar 1999 16:36:45 +0100
Message-ID: <36dea895$0$1512@newton> 





Matthias Gresz wrote


>- the row which was stored at first regarding timing





I don't hink that you can get this one, unless you also use a sequenced
column, or a timestamp? As far as I know, Oracle never guarantees which row
will be returned first.



So, just to be sure: using rownum < 2 might not get you the row that was first
stored regarding time.



Arjan.



Received on Thu Mar 04 1999 - 09:36:45 CST












Original text of this message













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