Re: RETRIEVING LAST X NUMBER OF ROWS FROM A ORACLE DATABASE TABLE

100656.1571_at_compuserve.com wrote:
>
> Does anyone know if how it possible to retrieve the last x number of rows added to a database table using a SQL statement.

That depends on the structure of your table and what you are looking for (inserts only or updates too). Are you using a sequence generator? If so you could select * from table where ID > than some variable representing the last record you ended the previous select on. I'm sure you get the idea. This won't give you updates however, or help you if your sequence generator loops.

Good luck

-- 

Craig Harper 
IFTN
(v) 415.583.4528
(f) 415.583.5536                                                                                                                                                                                                                               

Thinking is more interesting than knowing,
but less interesting than looking.