RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Web Applications
«Prev
Performance Tuning
Data Blocks
Database Block Size
Index Scan
Optimizing Space Usage
Segment Header Internals
Data Block Fundamentals
PCtfree Optimal Performance
PCtused Optimal Performance
PCT Used Optimal Performance
PCT Used Performance
Setting PCT Used Guidelines
Monitoring Tuning Indexes
Monitoring Tuning Indexes
Analyzing Oracle Index
Table High Water Marks
Water Mark Active
DB Engine Conclusion
Data Structures
Oracle Structures
Abstract Data Types
Using Oracle Objects
Oracle nested Tables
Oracle Varrays
Performance Conclusion
Data Dictionary
Performance Views
DBA Performance
Buffer hit Ratio
Building Alert Monitor
Oracle Data Dictionary
x-views
Partitioned Tuning
Partitioned Objects
Database Objects
Global Partitioned Indexes
Local Partitioned Indexes
Partitioned Index Maintenance
DB Partitioned Features
Index Techniques
Bitmap Indexes
Increase Query Speed
DW Star Schema
Star Transformation Queries
Star Transformation Process
Transformation Process
Using Concatenated Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
Issue updates with where
1) Gould's row contains the performance_flag, salary and name columns.
2) The UPDATE required is sent with a WHERE clause.
3) Each of the columns, are specified in the update command to ensure that they have not changed since the transaction began.
4) This re-validates all of the existing new values from the original display.
5) If any of these values have changed since the row was initially retrieved, Oracle willl reject the transaction, not perform the update, and will return a non-zero error status.
6) The database will return with a NOT FOUND SQL code.