Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fast select of first row on Oracle table...
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