Sometimes we forget some basic concepts. So do I (sometimes).

To retrieve the latest record of a table it’s not ALWAYS correct to use the max(rowid) of a table.

The rowid is an ID generated based on file/block/slot .

The only method to make sure we take the last record is a having a column with a timestamp or a sequence.

This entry was posted on Thursday, April 22nd, 2010 @ 7:19 pm on the category Database. You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback from your own site.