The differences in syntax are quite dramatic compared to other database systems like MS SQL Server or My SQL. Updates based on two or more common columns are normally used for tables where multiple columns work together as a primary key (known as composite primary key).
In this article, we are going to look at four scenarios for Oracle cross table update. Category_ID) where exists ( select * from Categories b where b. These columns uniquely identify a record in a table.
Cross table update (also known as correlated update, or multiple table update) in Oracle uses non-standard SQL syntax format (non ANSI standard) to update rows in another table. Update data in table A based on two or more common columns in table B.
(This is because the order in which the rows are updated determines which rows are ignored.) With this change, such statements produce a warning in the log when using statement-based mode and are logged using the row-based format when using mode.
(Bug #11758262, Bug #50439) See Section 184.108.40.206, “Determination of Safe and Unsafe Statements in Binary Logging”, for more information.
The WHERE clause ensures that only rows updated in the Customer table are those that have related fields in my Customer: Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”).
Progress Software Corporation makes all reasonable efforts to verify this information.