Re: Getting the first row from a select

A solution that is used is to add a column, e.g. ID number(10), and create a sequence for that column (ID_SEQ) which is incremented by one each time a row is inserted. Now you can retrieve easily the first row inserted. But remember that the column can be looped, thus when e.g. ID = 9999999999 exists and also ID = 1 exists then of course 9999999999 is the oldest record. Oracle thus not insert records in order of insertion, this has to do with tablespace use etc...

Erwin Received on Fri Oct 02 1998 - 00:00:00 CDT