Re: Select max(id) not returning correct value

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 20 May 2005 00:53:50 -0700 (PDT)
Message-ID: <20050520075351.92397.qmail@web52611.mail.yahoo.com>

Did you insert rows manually through one session without commit and do the max(id) from another session?

> select max(id) from mytable;
> It will not return 95 instead it will return value 5
> ?

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 20 2005 - 03:58:31 CDT