sql - Using a subquery instead of a table name in an Oracle Update Statement - Stack Overflow

Another option: UPDATE TABLE1 a SET a.COL1 = 'VALUE' WHERE a.FK IN ( SELECT b.PK FROM TABLE2 b WHERE b.COL2 IN ('SET OF VALUES') ) Your second example would work if (a) the view included the declared PK of TABLE1: UPDATE ( SELECT ...

stackoverflow.com