Re: Will ROWID change during DB Runing??

From: Grant Zhou <grantzhou_at_gmail.com>
Date: Tue, 4 Jan 2005 10:00:06 +0800
Message-ID: <crct7h$l2g@netnews.proxy.lucent.com>

Ed,
in my opinion, access the record with rowid is the most efficient way. We got the rowid when a call begin, and update the records when the call end with rowid.
The duration range: 3 seconds ~ 30 minutes, is it possible that the rowid be changed during this period?

Grant

"Ed Prochak" <ed.prochak_at_magicinterface.com> wrote in message news:1104506914.007695.296640_at_z14g2000cwz.googlegroups.com...
> ROWID really won't help you much in the situation you described. WHY do
> you want to use a pseudocolumn value for such a small table?
> using ROWID is generally bad idea, IMHO. (and in case you didn't know,
> I really dislike ROWNUM too.)
>
> If you are working with one customer account then use as Daniel
> suggests: SELECT ... FOR UPDATE;
> Or use your Primary Key.
>
> Ed.
>
Received on Mon Jan 03 2005 - 20:00:06 CST