Re: MAX NUMBER

From: sybrandb <sybrandb_at_gmail.com>
Date: 23 Aug 2006 05:56:30 -0700
Message-ID: <1156337790.768017.178690@m73g2000cwd.googlegroups.com>

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

Received on Wed Aug 23 2006 - 07:56:30 CDT