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: Matthias Gresz <GreMa_at_t-online.de>
Date: Fri, 05 Mar 1999 07:55:12 +0100
Message-ID: <36DF7FD0.3DB1630F@t-online.de>

Arjan van Bentem schrieb:
>
> 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.

Yeah, I didn't say that this will be possible without using some kind of timestamp, which then will be a case 1 problem, I only wanted to line out what different meanings "first row" may have.

Regards
Matthias
--
grema_at_t-online.de

Protect privacy, boycott Intel: http://www.bigbrotherinside.org Received on Fri Mar 05 1999 - 00:55:12 CST

Original text of this message

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