Re: update Is Oracle update a direct update in-place?

Fengqing Zhou wrote:
> My understanding for Oracle update is:
> All updates in Oracle are "Sybase direct update in-place".

  Any update on a non-clustered table will also result in same ROWID. As a result, it is on the same location logically. However, there is a possibility of row migration physically.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841