1) Oracle 多表更新方法: Oracle语法: UPDATE updatedtable SET (col_name1[,col_name2…])= (SELECT col_name1,[,col_name2…] FROM srctable [WHERE where_definition]) 例子: UPDATE A a SET ( a.a1, a.a2 ) = ( SELECT b.b1, b, b2 FROM B b WHERE b.b3= a