Multiple table update 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 he had done it in MySQL.

Update- What I am 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 it is possible using a "Instead-Of" trigger on a view.