Oracle SQL Update Multiple Values with Select Posted by Dino on June 24, 2011 Get link Facebook X Pinterest Email Other Apps 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
Comments
Post a Comment