Re: Will ROWID change during DB Runing??

Hans,
Thanks very much!
I am reading the books you mentioned.

But I only want to get one answer:
Will the ROWID change for a record if we only update the data? T/F :?
Best Regards,
Grant

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2005.01.04.02.56.39.959256_at_telus.net...
> On Tue, 04 Jan 2005 10:41:38 +0800, Grant Zhou wrote:
>
> > The program caused 3 user of 80K user charge error. I have doubts about
the
> > rowid usage.
>
> ROWID is very efficient if used correctly. However, it is not necessarily
> the correct technique to access a row, especially if there is an
> intervening commit.
>
> I agree that you are possibly seeing an example of incorrect usage.
>
> WHen you are ready to go to a supported version of Oracle (either 9i or
> 10g), add "Effective Oracle By Design" to your list of reading material.
> (Actually, a lot of the material is relevant for you right now, but I'm
> encouraging you to move up to a supported version. <g>)
>
> /Hans
>
>
Received on Tue Jan 04 2005 - 00:06:06 CST