批量更新

语句：

UPDATE TABLE_NAME_1 K SET (更新字段) =( 
     SELECT 查询要跟新的字 FROM TABLE_NAME_2 S WHERE S.ID = K.ID ) 
WHERE EXISTS(SELECT 'X' FROM TABLE_NAME_2 S WHERE S.ID=K.ID ) 
      AND 条件

例子：

UPDATE T_FACTOR_DG K SET (K.LIMIT_0) = ( 
   SELECT S.LIMIT_0* TO_NUMBER(1) AS LIMIT_0 FROM T_FACTOR_DG S WHERE S.ID = K.ID ) 
WHERE EXISTS(SELECT 'X' FROM T_FACTOR_DG S WHERE S.ID=K.ID ) 
   AND K.F_CODE I='500001'