Address last rows in a table

Hi,

We have a table wich as rows without any sequence (we can't change this because this is an application package) . Our problem is that we have to retrieve the last n rows inserted in the table.

Something like the

select * from table1 where rownum < 10

but for the last 10 rows instead of the first 10.

What we realy want is to retrieve the rows using something like a rowtimestamp or sequential rowid. As if the table got a sequence.

Thanks in advance,
Miguel Alves Received on Thu Jan 28 1999 - 14:13:37 CST