Oracle SQL Update Multiple Values with Select

UPDATE tgt SET ( tgt.x, tgt.y ) = ( SELECT src.x, src.y FROM src WHERE src.id = tgt.id ) WHERE EXISTS ( SELECT src.x, src.y FROM src WHERE src.id = tgt.id )

Comments