In Oracle, you can use the "UPDATE" statement with an "INNER JOIN" clause to update data in one table based on data in another. The "INNER JOIN" clause combines rows from two or more tables based on a related column between them.
Here is an example of how to use the "UPDATE" statement with an "INNER JOIN" clause to update data in a table named "table1":
UPDATE table1
SET table1.column1 = table2.column2
FROM table1
INNER JOIN table2
ON table1.join_column = table2.join_column
WHERE table2.column3 = 'value';
This query will update the "column1" in "table1" with the value of "column2" in "table2" where the values in "join_column" of both tables match and "column3" in "table2" is equal to 'value.'
You can also use the "UPDATE" statement with multiple tables using multiple "INNER JOIN" clauses.
UPDATE table1
SET table1.column1 = table2.column2
FROM table1
INNER JOIN table2
ON table1.join_column = table2.join_column
INNER JOIN table3
ON table2.join_column = table3.join_column
WHERE table3.column4 = 'value';
This query will update the "column1" in "table1" with the value of "column2" in "table2" where the values in "join_column"
0 Komentar