Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple SQL question
Hi,
This may not work because Oracle can insert records into empty space in the datafile rather than at the end of the datafile. Remember that RDBMS theory states that the order in which data is stored and retrieved is arbitrary and that any ordering of the data is derived from indexes, not from the sequence in which the data was stored.
If you want the ten most recent adds you could add a sequence column and then use the sequence as the basis for your query.
regards
Jerry Gitomer
William Dangren wrote in message
<37A84C30.E70F086B_at_navisent.com>...
>If you want the last 10 rows entered you will need to count the
number of
>records then select the last rownum between count-10 and count.
>
>Bill
>
>--
>William Dangren
>Navis Enterprises
>407.348.6401
>800.219.0207
>
>
Received on Wed Aug 04 1999 - 12:32:28 CDT