Cursors in oracle for updating all records examples
First, let's get a record of the current ROWIDs for each office and then delete two rows.
Interestingly enough, the ROWIDs for the two remaining rows are different from their original IDs before the delete statement.
The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.
As far back as Oracle 8.1.5 documentation, row movement applied to updatable partition keys.
A list partition where the partition key is a specific value is a good example of this.
Or two offices in the same city (from different groups or business units within the same company) merge into one location?
You could split the default partition and add the new location name.
The moral of the story here supports what the documentation says (in more than one place): Before you use rowids in DML statements, they should be verified and guaranteed not to change.Using ROWIDs to perform DML on records can be wicked fast, and is virtually the fastest way to access a row.However, if there is any chance that someone else's operation (and even yours) can alter the ROWIDs of a table, you can find yourself with lots of messy data. One of the relatively newer features in Oracle concerns the moving of rows. An early use of row movement was highlighted in Oracle8i, and row movement then, as well as now, applied to moving rows in a partitioned table.Why would a row move and who or what controls that movement? With newer releases of the Oracle RDBMS, where else does row movement come into play, and are there any gotcha's with respect to row movement operations?
How would you move records from the old partitioned into the new one?