Updating Multiple Tables in Oracle

Question

Is it possible to update multiple tables in Oracle with a single query using join? If so, what is the syntax? My colleague said that he did this in MySQL.

Update . What I'm trying to do is something like this

UPDATE table1 t1 JOIN table2 t2 ON t1.id = t2.id SET t1.column1 = 'ABC', t2.column2 = 'BCD' WHERE <condition>

Answer 1

What problem are you trying to solve? You cannot use a single update statement in Oracle to update multiple tables, but this is possible using the "Instead" trigger in the view.