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