Reiro wrote:
> so even tho the record 9999999 has been deleted and the max number i
> can see in the database in 200000. i wont be able to retrieve that
> value.... which in fact is the maximum number existing in the database.


You never posted the exact sql statement, did you?
But if the record was really deleted, *and* you *committed* the
transaction,
either your statement is wrong, or your understanding of Oracle, or
there is a serious bug in the yet still unknown version of your
database.

--
Sybrand Bakker
Senior Oracle DBA