As you have said, it occurs anytime the row is physically moved on disk, such as: Export/import of the table ALTER TABLE XXXX MOVE ALTER TABLE XXXX SHRINK SPACE FLASHBACK TABLE XXXX Splitting a partition Updating a value so that it moves to a new partition Combining two partitions If is in an index organized … Read more
From the Oracle docs ROWID Pseudocolumn For each row in the database, the ROWID pseudocolumn returns the address of the row. Oracle Database rowid values contain information necessary to locate a row: The data object number of the object The data block in the datafile in which the row resides The position of the row … Read more
In MySql you usually use session variables to achive the functionality: SELECT @rowid:=@rowid+1 as rowid FROM table1, (SELECT @rowid:=0) as init ORDER BY sorter_field But you can not make sorts on the table you are trying to delete from in subqueries. UPD: that is you will need to create a temp table, insert the ranging … Read more