Re: Last row?

You could query the table for the maximum rowid:

select * from <tab> where rowid =
(select max(rowid) from <tab>;

But this may not work if the last row got inserted into a different extent than the rest of the data. In such a case the last row could even have the LOWEST rowid. But in most cases the above query will work.

Jeff Seeman Received on Wed Sep 02 1998 - 19:14:51 CEST