Oracle sql更新多行

UPDATE 表名 SET 列名1 = 值1, 列名2 = 值2 WHERE 条件;

UPDATE employee SET salary = salary * 1.1 WHERE department = 'IT';

MERGE INTO 目标表 USING 源表 ON (条件)
WHEN MATCHED THEN UPDATE SET 列名1 = 值1, 列名2 = 值2;

MERGE INTO orders USING new_orders ON (orders.order_id = new_orders.order_id)
WHEN MATCHED THEN UPDATE SET order_status = '已发货';

BEGIN
  FOR i IN (SELECT * FROM 表名 WHERE 条件) LOOP
    UPDATE 表名 SET 列名1 = 值1, 列名2 = 值2 WHERE 主键列 = i.主键列;
  END LOOP;
END;

BEGIN
  FOR i IN (SELECT * FROM product WHERE stock > 100) LOOP
    UPDATE product SET price = price * 1.05 WHERE product_id = i.product_id;
  END LOOP;
END;